Saving record makes dataset point to first record ???

[mwitwer]

I am using Paradox Level 7 tables with the Native BDE Paradox drivers. I have noticed that after saving a record (I am actually using ApplyUpdates on cached updates thru a transaction) the dataset record pointer repositions itself on the first record. This makes it necessary for me to reposition it back on the record I just saved. Does anyone know why this behavior occurs? It seems to be causing me some problems in other areas.

Any advice will be helpful.

 

[Svanhooft]

hi,

The position is the first record of a database. If you do an insert in a database via SQL the position of the pointer isn't changed. Probaly you start with an select statement and then an insert. To view the record in the database you have to refresh the database and you are back at position one.

Steph [Bigglasses]