Hello, txwhytboy!
You wrote to <IBObjects@yahoogroups.com> on Tue, 09 Jul 2002 07:39:41 -0000:

>>> with DataModule1.IBDSQL1 do begin if not Prepared then
>>> Prepare;
>>> ParamByName('Field1').AsInteger := 0;

[Sorry, skipped]


Try this :
IBTransaction1.StartTransaction;
with IBDSQL1 do
begin
Prepare;
ParamValues['Field1']:=0;
Execute;
end;
IBTransaction1.Commit;
IBTransaction1.Close;

[Sorry, skipped]

t> Ok so Ive surrounded it in a IBTransaction.StartTransaction and a
t> IBTransaction.Commit around it... same problem.. Any more
t> suggestions?


WBR, Dmitry Beloshistov AKA [-=BDS=-]
e-mail: torin@...