At 08:55 AM 25-02-02 +0100, you wrote:

> >As for your many 1000s of lines of code...surely not every line is related
> >to data access?
>
>Of course, but most of them. If I want to change db layer to for example
>IBO, I think that I have change all database components (grids, combos
>etc). It's big work in the middle of supporting clients with current
>version. But of course we think about this. Do You suggest to change it as
>soos as is possible?

Yes. You have a buggy version of InterBase, with a known bug which is
corrupting your data. You have an out-of-date connectivity layer for your
application. It sounds to me as if you still have some work ahead of you.

btw, you can convert a BDE application directly to the IB Objects
TDatasource-compatible components, which use all of the VCL and third-party
data-aware controls that you are using now. You can even automate it with
a search-and-replace script and have your app up and running without the
BDE by the time you have made a coffee, to drink while you watch the
conversion. If it is a well-designed client/server application, it will
work as well under IBO, with better performance and no BDE vulnerability.

Sometimes, though, BDE applications are designed with desktop databases in
mind, e.g. using a lot of TTables and client-side cursor loops to do things
that, in a client/server system, should be done on the server, without
datasets. If yours has that kind of architecture then, until you repair
the design, your biggest gain from leaving the BDE will be in strength
rather than performance.

cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________