Hi, I am new to this forum. I am trying to replace an old Access application with Lazarus and SQLite. Using the tutorials and browsing this forum I have made some progress. Looking for a replacement for the DLookUp function I found this topic:
http://forum.lazarus.freepascal.org/index.php/topic,27940.msg173442.html#msg173442Unfortunately I get some errors I can't seem to solve.
In the lines 120 - 123
mySQl.DataBase := Database;
transaction.database := Database;
mySQL.transaction := Transaction;
mySql.text := Format('SELECT %s FROM %s WHERE %s = :veldwaarde',[veld,tabel,Lookupveld]);
The following errors are found:
Compile Project, Target: project1.exe: Exit code 1, Errors: 3
unit1.pas(120,38) Error: Incompatible type for arg no. 1: Got "AnsiString", expected "TDataBase"
unit1.pas(121,38) Error: Incompatible type for arg no. 1: Got "AnsiString", expected "TDataBase"
unit1.pas(123,11) Error: identifier idents no member "text"
I am using Lazarus 1.6.4 and SQLite3
I hope someone can help me to understand these error messages and suggest how to solve them.
Bert