General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>If I understand it correctly...If I move the record pointer in the base table the record is committed and can't be reverted with the cancel button.
>
This is only with Record Buffereing... if you enable TABLE buffering you can move the pointer. Actually, this is the ONLY way to enter multiple records into a view an then saving them with ONE save.
If you set your buffering to OptTable Buffering and you index the view on the primary field you will be able to use indexseek() on the view. If the view is small, you don't even need an index, and just use LOCATE. It is pretty fast when dealing with 10 records. :)
>The only way I can find a record is if I search the base table which works fine until I hit cancel to revert the records they don't all get reverted.
>
Another option is to not populate the Key Fields until you SAVE the records. If course, if you are using Business Keys instead of surrogate keys this is not possible.
If you are using Business Keys, you will have to search the Buffered View and the unerlying table for the Key... not to hard though.
HTH,
BOb
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only