Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto-incrementing a number field
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00168371
Message ID:
00168516
Views:
21
I dissagree with using RECCOUNT(). This will open up a "can of worms" if you decide to PACK your table.

By using a SELECT MAX(field) you will get the highest value for that field which can then be incremented by one.
Juan L. Romero
gcandela@javanet.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform