Hi Programmers,
I would like to work with SQLite3 in Lazarus, but I am a beginner. May I ask you, would somebody patient help me step by step to process it, please? I must do something total wrong :-/
I made a test.db in SQLite Administrator and tried to connect in Lazarus through the TSQLite3Connection, TSQLTransaction and TSQLQuery, but if I select TSQLQuery -> Activ - there is still some warning message (Transaction is not set).
May I ask you – do I understand well?
1) The SQLite database could be only a file created e.g. by SQLite Administrator, I can place it in the same folder like the project, ok?
2) The sqlite3.dll library could be placed also in the same folder like the project, ok?
3) TSQLite3Connection – Database Name = C:/pascal/test1/database1.db
3a) How about the slash - / or \ - C:/pascal... or C:\pascal...?
4) SQLiteLibraryName:=’C:/pascal/test1/sqlite3.dll’;
4a) or can I use relative path './sqlite3.dll';
5) TSQLQuery – SQL = SELECT * FROM table1
Any idea whats wrong, please?
Or would somebody have some easy project with SQLite (e.g. easy adressbook…), which could send me by email as I could understand it just from the code and setting?
Thank you all very much for any help…
George