Delphi6 Interbase Querys and Transactions handling
Posted on 2006-05-24
I am new with Interbase/Firebird development, currently I am developing client server applications with Firebird using Interbase
components that are ship with Delphi 6 Enterprise.
I my plan is to develop small seperate .exe and then from a main menu application to
call each .exe as needed. The reason i am doing this is, If a problem occurs in a program then I can
quickly fix the program and the client are not affected in any way...I hope this is the best way..
Now my problem is as follows... In all my application I have a datamodule, in the datamodule
I got TIBDatabase component and a TIBtransaction component.
At this stage the properties of the tibtransaction are default.
My application do a normal select staments like this one.
with qryData do
sql.add('select * from emp');
We I nedd to Update data, I call a stored procedure and all my code to update or insert are in the stored procedure.
NOW... my data doesnt refresh if I call my select statement, the old data still shows, but if I exit the app and re-run the application
the updated data are there.
Also If I run two seperate Instances of the same application on my pc, and i run a select and do a update, and i go to the
other exe and run the same select the updated data doesnt show...
HOW MUST I USE TRANSACTION, AND WHAT IS THE RIGHT WAY OF USING TRANSACTION, please i am desperate for help.
One more thing... I dont depend on dbnavigator to update or delete or to refresh data, I right my one select and use
stored procedures to insert/update data.