Lazarus with SQLite Database not working
lazarus / 16-Databases

----------------------------------------------------------------------
jordicg · 2021-02-20 23:38

Hello community !!

I am trying to create a Database Application, i have done the
connection with a SQLite3Connection control a DataSource a
SQLTransaction and a SQLQuery controls, but when i run the application
theres no error or warning shown, when i try to add a new record to
the database with the Navigation controls nothing happens, neither a
error is shown, i have added a line of data to the database but it is
not displayed by the DBEdit controls and checkboxes. Any help is
appreciated.

----------------------------------------------------------------------
egsuh · 2021-02-20 23:55

You have to set
       SQLTransaction.Database = SQLite3connection
       SQLQuery.dababase = SQLite3connection
       datasource.dataset = SQLQuery

       DBEdit.datasource = datasource
       DBNavigator.datasource = datasource
     
If you are beginner, you'd better start with TDBGrid.
      
To view the content of database, your SQLQuery.SQL = 'select ....'.

----------------------------------------------------------------------
Jurassic Pork · 2021-02-21 00:20

hello,
have a look in my sqlite database example deadly mushrooms in the
folder lazarus\examples\database\image_mushrooms of Lazarus
distribution.
Friendly, J.P