Lazarus + Sqlite := 'SQLITE_NOTADB'
lazarus / 16-Databases

----------------------------------------------------------------------
Lathspell · 2006-02-11 10:39

Hi everybody!
Following a guide posted by an user in theese days, I have installed
the TSQLITE2DATASET component and create some tables with it, so I put
this component and the TDATASOURCE on my main form.
Then I have linked the TDatasource to the Dataset with its "DataSet"
property and put two TDBEdit in the form linking them to the
TDataSource.
Then I try two ways:

1st: Set the "Active" property of the TSqlite3Dataset on TRUE
2nd: Use this code:

Code: [Select]
{ dbMain is the TSqlite3Dataset name }
dbMain.TableName := 'clienti';
dbMain.SQL := 'Select * from clienti';
dbMain.Open;


In both cases, lazarus return an error:

dbMain: Error returned by sqlite while retrieving data: SQLITE_NOTADB


What I have to do?
(I apologize for my awful english)

----------------------------------------------------------------------
LuizAmérico · 2006-02-23 23:54

Do you set FileName to the datafile path?
How do you created the datafile?
The datafile is from sqlite2 or sqlite3 ?

The error means that sqlite does not recognizes the datafile
(FileName) as a valid sqlite3 database.