Subject Re: [firebird-support] FB Newbie - data access components?
Author Woody (TMW)
From: "Lauchlan Mackinnon" <lmackinnon@...>
> > The TIBUpdateSQL component can link to one of the tables in the query
and
> if
> > the query would normally
> > return a readonly dataset and will allow you to update this table.
>
> ok, got that . . .
>
> But I'm not sure how to actually code the update etc SQL statements.
>

Although you can use the TIBQuery and TIBUpdateSQL together to provide live
datasets for editing, it is generally much easier to just use the TIBDataset
component which is basically a combination of them. It can help you
automatically generate the needed statements for updating, deleting,
inserting, etc. It will probably be much easier for a beginner to use than
TIBQuery or TIBSQL. I generally only use the TIBQuery, TIBSQL for retrieving
non-live data since they have a little less overhead than the TIBDataset.

HTH

Woody (TMW)