[SOLVED] Any good examples with dbgrids out there

[BigChimp]

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]

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 ...