General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>The usual approach to editing and adding records is to use Optimistic Buffering.
This is what I've done. lsuccess = CURSORSETPROP("BUFFERING", 5)
>Any new record will have a negative recno().
When I append blank to the cursor I have a positive recno() No?
>You can confirm the record with TableUpdate(), or undo changes with TableRevert().
Yes.
>Even a deletion requires TableUpdate(), if you use buffering.
Yup.
>The records will not be posted to the server, until you issue TableUpdate().
Yes but I have to get the next available nunber from the table that stores them. Before I can issue the TABLEUPDATE().
They want to add a record. Then open the database and change the value in the primary index field of the tables. How do I get a cursor from the database that will have no records? I know with a view NODATA I think gets an empty view.
>HTH, Hilmar.
Previous
Next
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