[SOLVED] Any good examples with dbgrids out there
lazarus / 16-Databases

----------------------------------------------------------------------
BigChimp · 2011-09-04 18:03

Hi all,

Let me put my questions another way. Are there any nice Lazarus
examples with dbgrids with select,insert,edit functionality out there
for e.g. Firebird, DB2, MySQL, PostgreSQL, MS SQL Server, MS Access,
Oracle?

I'm still stuck on inserting from a grid (see earlier post), maybe
there's an example I haven't seen..

thanks!

***edit: original question was solved. Still interested in nice sample
applications, but not so urgent any more

----------------------------------------------------------------------
IPguy · 2012-01-05 01:45

I just ran across this example and bits of it worked for me.
http://pp4s.co.uk/main/tu-form-dbgrid-update-laz.html

Their "view" table did not work as well as mine.

Theirs:
Code: [Select]procedure TfRCMMain.bGetTblClick(Sender: TObject);
begin
  SQLQuery1.Edit;
  SQLQuery1.Post;
  Sqlquery1.ApplyUpdates;
end;                  
Mine:
Code: [Select]procedure TfRCMMain.GetTableGroupClick(Sender: TObject);
begin
  SQLQuery1.Close;
  SQLQuery1.SQL.Clear;
  SQLQuery1.SQL.Text := 'select * from Groups';
  SQLQuery1.Open
end;          

And while I liked their insert code which updated the DBGrid, it did
not update the d/b.   Ditto with their delete line code.

The discovery continues ...