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
