Existing Sqlite 2 database problem...
lazarus / 16-Databases

----------------------------------------------------------------------
joseywales72 · 2011-09-12 13:55

Hi,
I searched the forum but couldn't find a solution, so here is my
problem.
I have a Sqlite2 db, I set up a prototype application, using the
sources at http://sqlite4fpc.yolasite.com/dataset-tutorial-1.php,
replacing Sqlite3 references with Sqlite. Of course I did not add a
Create DB function, but I set the SqliteDataset controls properties as
such: Filename, as the db file, primary key and index field as the
ones in the table, table name as it is etc. But when I set the
property active to true, it gives this error:  SqliteDataset1 :
SQLITE_ERROR - SQL logic error or missing database
I can open the database with commandline usage of Sqlite and dump the
tables etc. I have Sqlite2 installed.
Is there any simple example for Sqlite2 for opening an existing db?
Thank you.
Anil