Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto Generate user ID
Message
From
13/03/1997 11:55:04
 
 
To
13/03/1997 11:37:31
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00024106
Message ID:
00024114
Views:
43
>Hi, Can anyone help on how can I create auto generate user ID on the Form Generator??

Basic way to create unique ID:
1. Have a table 'Counters' with 2 fields: tablename,counter.
2. Write procedure 'CreateId' accepting Tablename parameter.
3. Call this procedure: locate record in Counter (by Tablename), lock this record, take counter as new Id, increment counter, unlock record, return new Id.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform