[SOLVED] SQLdb &  Firebird can not insert nor edit
lazarus / 16-Databases

----------------------------------------------------------------------
finalist · 2011-09-10 12:22

I have created Firebird database with one simple table by IBExpert. I
have posted 2 records into the table by IBExpert too.
I can read these records using SQLdb components:
TIBConnection, TSQLTransaction, TSQLQuery, and DataAccess componets
TDatasource, TDBGRID.
At runtime I can only see readed 2 recods, browse them, but I can not
insert nor edit. It seems temporarily it is inserted a new record, but
when I close the Application and run it again, there is no new record.
It seems temporarily an edited record, but  when I close the
Application and run it again, there is no changed record.
( I have different problems trying to use Zeos components )
Thank you in advance!

----------------------------------------------------------------------
marcov · 2011-09-10 13:16

Add a dbnavigator, and press the "v" like mark after editing and see
if that fixes your problem

----------------------------------------------------------------------
finalist · 2011-09-10 13:28

Sorry, but my problem is not solved.
I did drop a TDBNavigator, then connect it with TDataSource.
I Ran the Application, pressed the button '+' for inserting a new
record, writed into the fields, then pressed the button 'v' -
everithing seems to be o.k. but after closing and running the
Application, there is no new record ...
( Code Typhon Version 1.80;
Lazarus Version #: 0.9.31 )

----------------------------------------------------------------------
Lacak2 · 2011-09-13 05:19

You must :
1. SQLQuery1.ApplyUpdates
2. SQLTransaction1.Commit

----------------------------------------------------------------------
finalist · 2011-09-13 06:49

Quote from: Lacak2 on September 13, 2011, 07:19:53 amYou must :
1. SQLQuery1.ApplyUpdates
2. SQLTransaction1.Commit
Thank you very much !
Now my inserts and edits are posted into database - that's great