Sigh. Since you're using BDE, I should probably let someone
else answer this, but basically, here's the deal. InterBase
is a database which provides ACID transactions. One of the
aspects of aCidity is that within a transaction, data is Consistent.

The right answer:

To see new data, start a new transaction.

The pragmatic answer:

InterBase does make some (in my mind unwise) compromises to
work the way non-database people think. You should set good
old BDE to read committed, shadow, wait.




Regards,

Ann
www.ibphoenix.com
We have answers.