----- Original Message -----
Sent: Friday, June 22, 2001 8:59 AM
Subject: RE: [DUG]: Connecting to
Interbase
Good. There are two main methods of access in IBO;
one designed to maintain compatibility with BDE (the access methods are
like-named) and another which apparently is more powerful but you lose that
relatively seemless BDE interchangeability. I am using the former. I am
avoiding the supplied controls (QBE data aware dbedits eg) so I can leap back
to BDE if needed without too many tears. But if I were to use these extras
life would be astoundingly simple (ie searching a dataset using my data entry
form by changing one property).
To
date I've had no dramas at design or runtime. There are some pretty nifty
features when working with datasets such as (in design mode) the ability to
execute the query and then populate a table (great for lookup tables), in the
query builder defining what happens to null values/ force case sensitivity/
insensitivity etc. Everything seems to work, error messages make sense and I
work just like with the BDE. And I'm access the DB natively, so I guess there
will be subtle performance advantages. My only gripe (a small one) is having
to pay for the manual, which to date I haven't needed.
My
main objective in going to IBO was making the most of a more scalable DB (IB
over Pdox), fixing the stupid stored procedure problem I was having and being
able, relatively easily, to be able to port back to BDE for whatever reason.
In those respects its a success - I'll let you know when I get tripped up but
I have a feeling you will be waiting a while : ).
James
Would be interested to hear how your move to IBO
went.
Mark
----- Original Message -----
Sent: Thursday, June 21, 2001 3:42
PM
Subject: RE: [DUG]: Connecting to
Interbase
Yep - that is what I discovered too. At the
point, and after finding a few limitations with manipulation of stored
procedures I moved to IBO.
Hi
With my Paradox database I could just use an
OpenFileDialog to point to a file in the Database directory to set this
before opening tables. ie I did not have to have an Alias set up
in the BDE.
It seems that to connect to Interbase (at this stage
using the BDE) I must have an Alias set up.
Can someone confirm this for me please (it might save
a lot of time wasting for me trying to do what can't be
done)
TIA
Mark
