Subject Re: [firebird-support] FB Newbie - data access components?
Author Lauchlan Mackinnon
> The IBX components provided with Delphi work OK with Firebird 1.5. You
just
> have to manually set the database
> name to one with an fdb extension.

Thanks Graeme. That worked.

Just to check: I wired a TDataSource to a TIBQuery/TIBTable to a TIBDataBase
to a TIBTransaction.

I assume that that's correct and all that is required?

Also, the TIBDataBase had an option for login prompt. To turn this off, I
had to set parameters for username and password in the TIBDatabase. There
were no properties specifically for username and password. Is this correct,
and is this safe?

Another quick question: I couldn't edit the data when feeding the grid using
the TIBQuery - I assume this is as designed, and the query result set is
read only?

What do you do typically do in FireBird when you want to work with data
(represented ina grid) that is the result of a join from multiple tables?
Multi-tier frameworks (RemObjects DataAbstratc, kbmmw etc) typically offer
mechanisms to resolve the data inserts and changes to the appropriate
places - is this possible with FB in C/S mode? Should I be using a
TIBDataSet component for this?

> I don't know if they are necessarily the best ones to use in the long run,
> but they will work.

I expected as much! <g>

Good for getting started with, though.

Any suggestions on the pros and cons of which components to choose "in the
long run"? From a quick look on vendors websites and ng's, the FIBPlus ones
sound good.