ADO vs Interbase components

ADO vs Interbase components

Post by Wayne Nidd » Mon, 18 Aug 2003 00:38:26



Use a TIBDataset component for read/write purposes. For read-only needs, use
TIBQuery if you need to attach data-aware controls, otherwise use TIBSQL
(best performance).

IBX is preferable for connecting to Interbase. The only reason not to use
IBX is if you know you must support more than a single database type, then
you should look at dbExpress (or possibly ADO).

For most purposes, you need one TIBDatabase, one TIBTransaction, and any
number of datasets (TIBDataset, etc).

--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.yqcomputer.com/
"It is error alone which needs the support of government. Truth can
stand by itself." - Thomas Jefferson
 
 
 

ADO vs Interbase components

Post by James Cre » Thu, 21 Aug 2003 05:09:10

Wayne:

I am using TIBQuery with an associated TIBUpdateSQL to provide
Update/Delete capability rather than the TIBDataset. What is the bad and
good on that? How do you provide master detail relationships with TIBDataset
to support thing like QuickReports. I am using TIBTable now but want to
replace it with TIBDataset since TIBTable is a no no.

Thanks:
James Crea



use

 
 
 

ADO vs Interbase components

Post by Wayne Nidd » Thu, 21 Aug 2003 09:45:51


If the TIBUpdateSQL is working for you then no need to replace it.
Master/detail works with TIBDataset by hooking up the Datasource and
specifying parameters for the fields representing the relation in the SQL of
the detail dataset. Try to get rid of the TIBTable, you can use TIBDataset
or TIBQuery, whichever is more confortable for you.

--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.yqcomputer.com/
"It is error alone which needs the support of government. Truth can
stand by itself." - Thomas Jefferson
 
 
 

ADO vs Interbase components

Post by James Cre » Sat, 23 Aug 2003 07:23:13


Try to get rid of the TIBTable, you can use TIBDataset

Unlike TIBTable, when I try to modify a record entry (Via FieldByName) in a
While EOF ... Next loop, the TIBDataset does not scan down the list of
records in the dataset. The Cursor stays on the first entry. If the loop is
read only, then the loop will scan down to the EOF. What am I doing wrong?

Thanks
James Crea