- Drop a SqlitePassDatabase and a SqlitePassDataset on your form (named SqlitePassDatabase1 and SqlitePassDataset1).
- Connect SqlitePassDatabase1 to a db (tested with a kexi db in /demo/database). Connected := True
- Connect SqlitePassDataset1 to SqlitePassDatabase1.
- Select a table, query or enter your select sql statement
- Set SqlitePassDataset1.Active := True;
- Drop, for example, a memo + a button on your form and assign the button.onclick event.
procedure TForm1.Button1Click(Sender: TObject);
begin
SqlitePassDataset1.Next;
Memo1.Lines.Add(SqlitePassDataset1.Fields.FieldByName('Name').AsString);
end;
This will display the value of the field 'Name' every time you click the button.
This is just a quick/dirty example. Let me know if you need to achieve a specific task.
Regards.
Luc.