Page 1 of 1

Live Update

Posted: 05.01.2008, 15:08
by williamhur
Hellow, guys,
I have global temporary table with oracle 10g and
try to insert, delete, modify.
Incase insert as 'insert into TABLE ----'
'delete ---', 'update Table set ----' work very well.
But I can not do 'ApplyUpdate' procedure
after select dedicate record with sql query.
Like...
Query.sql.clear;
Query.Sql.add('select * from TABLE where key = ''1'' ');
Query.open;
If Query.recordcount <> 0 then
begin
Query.edit;
Query.FieldByName('a').asstring := 'UpDate';
Query.ApplyUpdate;
end;
I have access violation error.
The other way I can find update data
when I use UpdateSQL like
'Update Table set ---- ';
Are ther any solution using direct Edit, ApplyUdate procedure
instead Update SQL.

best regards,
willy :roll: