Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Design ? - Incremental number needed when appending
Message
From
13/01/1999 15:14:08
 
 
To
13/01/1999 12:13:17
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00175528
Message ID:
00175650
Views:
29
>>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.

Thanks for pointing me in the right direction. I have it working great now with an updatable view and the stored procedure.
Previous
Reply
Map
View

Click here to load this message in the networking platform