Problem getting a demo SQLite app working in Lazarus (OSX)
lazarus / 16-Databases

----------------------------------------------------------------------
paulkp · 2014-03-03 03:57

Hi all

I'm having a Problem getting a simple demo SQLite app working in
Lazarus (OSX).

I've got a non-empty SQLite DB and the SQLite library
libtclsqlite3.dylib in my project folder.
I've added the SQLite3Connecton, SQLTransaction, SQLQuery, Datasource
and a DBGrid.

On an iMac OSX 10.8.5 with Lazarus 1.0.14

At design-time, I can see the FIELDS of any table I want in the
SQLQuery component.
But I can't see any records in the DBGrid at design OR run-time.

Code: [Select]procedure TForm1.Button1Click(Sender: TObject);
begin
  SQLQuery1.SQL.Text := 'select * from sentenceTBL';
  SQLite3Connection1.Connected := True;
  SQLTransaction1.Active := True;
  SQLQuery1.Open;
end;

----------------------------------------------------------------------
jeanchristophe · 2014-03-03 10:33

Do you have a datasource for the DBGrid?

Best Regards
Jean-Christophe

----------------------------------------------------------------------
paulkp · 2014-03-03 11:08

(Yes I do have a Datasource)

Sorry folks, someone helped me solve it.

I had a circular reference . . It works now! I feel like I've got
Delphi back after an 8 year break.