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

[Usuario Anónimo]

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:

Close;
Sql:= 'select XXX';
Open;


Luiz