Hi
Could someone help with this one.
I have to rewrite a Delphi application which records customer contact information and is used in the Sales Office of my customer.
I have a main form with sqlquery, sqltransaction, sqlite3connection and datasource. There is also a DBGrid and a DBNavigator. The sqlite3connection is linked to a sqlite3 database.
Getting the DBNavigator to work is the problem.
I need to be able to edit and change records and to add and delete records. Whenever I try to do any of these including clicking the Post button nothing happens. The changes are not recorded in the datatable and they are not retained in the grid.
I recall that in Delphi you could drop a Navigator component onto a form, connect it to the datatable and it would work "straight out of the box". It seems more complex with Lazarus.
Perhaps some code is needed ? Perhaps the answer lies with sqlquery ?
Could someone tell me exactly what is required to get DBNavigator working properly.
Many Thanks