INSERT IBconnection+transaction+SQLquery+Datasource+dbedit
lazarus / 16-Databases

----------------------------------------------------------------------
abmservice · 2009-08-14 20:36

LAZARUS 0.9.27
FIREBIRD 2.1
WINDOWS XP

IBconnectoin(SQLdb)
sqltransactoin
sqlquery
datasource
dbedit

INSERT

begin
sqlquery.post;
sqlquery.applyupdates;
sqltransaction.commit;
end;
After adding a record to a database other components connected to
SQLQuery IBconnectoin be disconnected. Why? What's wrong?

----------------------------------------------------------------------
clauslack · 2009-08-18 23:49

Maybe when you commit an insert, after you must do a select in a new
transaction.

You can try this example for select-insert with Firebird.
Change in FormCreate the parameter for you Firebird database.

Upload sql_example.zip
Tested under
- Windows XP SP3 and Linux
- Lazarus 0.9.27 svn 21289 fpc 2.3.1 svn 13383/fpc 2.2.4.
- Firebird 2.1.2


Regards

----------------------------------------------------------------------
Loesje · 2009-08-25 16:21

.Commit commits and closes the transaction. All other datasets/things
within the same connection are also closed. You need .CommitRetaining
which keeps the connection open.