Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Autoincrement fields
Message
From
13/08/2004 12:11:59
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00933021
Message ID:
00933173
Views:
28

The view is opened with NODATA. After doing a TABLEUPDATE(1) to commit the new record, the view is not updated with the value that was auto-populated in the incremented field. Considering the view has no filter criteria, doing a REQUERY() will simply get all the records from the underlying table.

I wanted to avoid using one of the other fields (for internal use and not populated at the creation of a record) to hold a temporary unique reference. I was just looking for a cleaner way to get the primary key.


Try this:
IF TABLEUPDATE(1)
  REFRESH()
ENDIF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform