Joe Hatem wrote:

> An opinion, anyone ?

> When I insert a new record with key-value "A2",
> in BDE-Interbase, after insert, I see the following sequence:
> - A0
> - A1
> - A2
> - A3
>
> whereas in IBO-Interbase, after insert, I see the following sequence:
> - A2
> - A0
> - A1
> - A3

Unfortunately both are probably right. To get a 'correct' order you need
to ensure that there is an ORDER BY. In order to ensure that coming from
BDE, I 'think' that you need to make sure the correct index is being
used on the table. It's been a long time since I gave up with BDE, but
while some times it gave the right 'default', not having selected a
correct index did give similar random results IN BDE. My solution was to
switch to Queries quite quickly, while an application CAN be converted
BDE->IBO, I found that a clean build of some sections made a lot of
difference to both performance and the feel of the application.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services