Subject | BDE replacement |
---|---|
Author | peremart |
Post date | 2002-03-06T07:19:26Z |
We have software applications (Delphi 5 + BDE) for financial clients.
Some use Oracle as DB. Others MS-Sql. Majority Interbase (our
selection). In the delphi code can see:
if bbdd = 10 then sql := sql + ' LEFT OUTER JOIN TABLE2 T2 ON ...
else if bbdd = 20 then sql := sql + ', TABLE2 T2 WHERE T1.CODI = T2.
CODI (+) ... etc. etc.
We prefer to have ONE only program and not three flavors for different
Databases. Then can't use ibx, ibo et all.
The Midas/Asta/etc. way is for us a excesive rewrite of our software (I
think).
Now I want use Firebird dialect 3. I suspire for the precision of a
field NUMERIC(15,2).
My question: Is Db-express (Delphi 6) suitable for database access in
this scenario?
How about zeusdbo?
Any other?
Thanks and sorry for my sioux-like english...
Pere
Some use Oracle as DB. Others MS-Sql. Majority Interbase (our
selection). In the delphi code can see:
if bbdd = 10 then sql := sql + ' LEFT OUTER JOIN TABLE2 T2 ON ...
else if bbdd = 20 then sql := sql + ', TABLE2 T2 WHERE T1.CODI = T2.
CODI (+) ... etc. etc.
We prefer to have ONE only program and not three flavors for different
Databases. Then can't use ibx, ibo et all.
The Midas/Asta/etc. way is for us a excesive rewrite of our software (I
think).
Now I want use Firebird dialect 3. I suspire for the precision of a
field NUMERIC(15,2).
My question: Is Db-express (Delphi 6) suitable for database access in
this scenario?
How about zeusdbo?
Any other?
Thanks and sorry for my sioux-like english...
Pere