Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Design ? - Incremental number needed when appending
Message
From
13/01/1999 12:13:17
 
 
To
13/01/1999 12:09:59
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00175528
Message ID:
00175531
Views:
24
>I'm using VFP 6.0 and the included framework for an application. In this application, for only one paticular form, I need to assign each record added to the table an incremental number (a response number). The form uses the standard navigation toolbar which has an add button. How would I design the application to assign the next response number to the next record added.
>
>Is there any way to use the table trigger to do this?
>
>Should I modify the add botton on the tool bar? To check what form is active and if this paticular form is active then get the next response number from a control file? If I use that approach how would I check to see what form is active?

You can have next number generating function and put it into appropriate field (primarykey) default value. Look at Tastrade sample.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform