BorlandTalk.com

Predrag Cabarkapa · Guest

Hi,
try this :

with query1 do
begin
sql.add('begin transaction');
sql.add('exec sp_name param_1,...,param_n')
sql.add('insert table1 (a1 )values (''asdfghj2'')');
sql.add('rollback transaction');
execsql;
sql.Clear;
sql.Add('select * from table1');
open;
first;
end;

best regards

Predrag Cabarkapa
e-mail:
[email]zcharlie54 (AT) hotmail (DOT) com[/email]
[email]zcharlie65 (AT) neobee (DOT) net[/email]