Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auto sequence implementation in VFP
Message
 
À
18/07/1999 21:18:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00242922
Message ID:
00242936
Vues:
23
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform