Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving an empty cursor
Message
From
31/08/2001 09:13:28
 
 
To
31/08/2001 09:00:41
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00551332
Message ID:
00551339
Views:
22
>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
Map
View

Click here to load this message in the networking platform