A very simple example of displaying data on a form from an SQLite table. The SQL select is hard coded in the SQLQuery1 object. Only the grid is visible. Anywho I successfully compiled and ran a simple SQLite program. Returning values in a data grid,
Visually it looks like this
Behind the scenes Lazarus creates unit1.lfm. See the text below. The 5 objects below are physical objects on the form as seen above. The description in the parentheses (which I added) tell in what tab where the object can be found. The bolded lines are properties for the object that I set. And looks like this... object SQLite3Connection1: TSQLite3Connection (in SQLdb tab) Connected = True LoginPrompt = False AfterConnect = SQLite3Connection1AfterConnect DatabaseName = '/home/bill/Mystuff/SQLite/judoplaces.db3' KeepConnection = False Transaction = SQLTransaction1 HostName = 'localhost' AlwaysUseBigint = False Left = 31 Top = 34 end object SQLTransaction1: TSQLTransaction (in SQLdb tab) Active = True Database = SQLite3Connection1 Left = 31 Top = 96 end object SQLQuery1: TSQLQuery (in SQLdb tab) IndexName = 'DEFAULT_ORDER' MaxIndexesCount = 4 FieldDefs = < item Name = 'Code' DataType = ftAutoInc Precision = -1 end item Name = 'AKC_Group' DataType = ftString Precision = -1 Size = 20 end> Active = True Database = SQLite3Connection1 Transaction = SQLTransaction1 SQL.Strings = ( (SQL Select) 'select * from akc_group;' '' ) Params = <> Left = 104 Top = 192 end object DataSource1: TDataSource (in Data Access) DataSet = SQLQuery1 Left = 163 Top = 34 end object DBGrid1: TDBGrid (in Data Controls) Left = 125 Height = 78 Top = 100 Width = 156 Color = clWindow Columns = <> DataSource = DataSource1 ParentFont = False TabOrder = 0 end