[Lazarus] FreePascal/Lazarus Components to access Sqlite databases --> Tutorial 01 - A basic address book

Usuario AnĂ³nimo usuarioanonimomysql at gmail.com
Fri Sep 12 16:30:09 CEST 2008

Usuario AnĂ³nimo wrote:
> What difference exist between
> dsTest.ExecSQL('Select * from Vendor where Code = 0');

ExecSql is used to commands to modify the database state like Insert, 
Update, Delete, Create Table
> and
> dsTest.SQL := 'Select * from Vendor where Code = 0';
SQL is used to retrieve data, i.e, the Select command. It must be 
followed by the Open method. So to retrieve the data you must do:

Sql:= 'select XXX';


More information about the Lazarus mailing list