Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto sequence implementation in VFP
Message
 
To
18/07/1999 21:18:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00242922
Message ID:
00242936
Views:
15
>Definitely read somewhere but can't recall. Is the only to implement sequence ( in Oracle terms ) in VFP to increment integer field in insert trigger ?

Michael,

You cannot increment through the insert trigger as it does not allow any changes to teh table that the trigger fired for.

I have a udf that calculates the next integer ID and is called from teh Default option of the PK field for the table.
Previous
Reply
Map
View

Click here to load this message in the networking platform