Lauchlan,

You can set the parameters directly in the database component or you do it
programmatically.
I personally always turn off the login parameter screen and provide the
login credentials
programmatically.

Obviously the programmatic approach is required is you wish users to provide
login details.

To make the IBQuery editable, you will need to attach a TIBUpdateSQL
component to the query,
set cachedupdates to true and generate the SQL statements necessary within
the TIBUpdateSQL
statement.

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.If you
want to update more than one
table, there are also less straightforward ways of doing this.

You will need to the applyupdates and Transaction.Commit commands at some
point to actually save
the edits you have made in the grid.

We will be looking at new components in the near future to replace the IBX
components as they depend
on the patched gds32.dll file provided by the firebird install which fools
IBX into thinking that it is running
Interbase. I believe that support for this patched file will be dropped as
of version 2 of firebird.

There have been many past articles comparing the various options and IB
Objects seems to come out ahead.
We will be evaluating it ourselves within the next few months. I suggest
that looking back through the newsgroup
will provide plenty of information about comparisons between the different
delphi components.

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Lauchlan Mackinnon
Sent: Saturday, 25 June 2005 7:05 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FB Newbie - data access components?

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





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]