Re: commit problem


2003-08-24 07:37:48 AM
delphi126
Cristian writes:
Quote

Hi,
i have a appl. in D7. When I insert/update/delete an row from a table (using
stored procedure)the change only apply when I close the application. Ex:
table person
field name = 'Dan'
Update ....... name= 'Mike'... . In my appl the update appears but when I
connect to the database from ibconsole no change is made. I close my appl.
and the change appears.
I used TIBStoredprocedure and TIBQuery with commit transaction but no
effect.

It sounds like you are not calling commit. IBX does not auto commit for you.
The Default Action fires when the IBTransaction is destroyed and that defaults
to commit.
Quote
Any ideea or link to some documentation will help.

Thanks Cristian
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
If there is somebody up there could they throw me down a line. Just a
little helping hand just a little understanding. Just some answers to the
questions that surround me now. If there's somebody up there could
they throw me down a line. (Fish)