Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EDITing OR APPENDing to LOCAL VIEWS
Message
From
26/11/1999 10:38:17
 
 
To
25/11/1999 15:41:34
John Vlahos
V I Software Solutions Design
Mississauga, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00295056
Message ID:
00295718
Views:
17
>In VB every record created can have an automatically incremented primary key, when using Access data files.
>

Yeah, the counter field type is nice in Access.

>Can VFP table be structured to do the same automatically? If not, what do you suggest would be the most efficient and valid way of creating a value to be used as a unique primary key in a multi-user environment?

We don't have a field type that takes care of this, but most of us use a strategy that acheives the same effect: use the default value property for an integer field to call a stored procedure that looks up the next available id in a second table that stores only table names and ids.

For an example, look at the TasTrade sample that ships with VFP.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform