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