Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get next sequence from Oracle
Message
 
 
À
19/01/2001 18:02:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00465909
Message ID:
00466066
Vues:
10
>>>Is there a function I can call from VFP (using SPT) to get the next sequence from Oracle?
>>>e.g., I know I call NewID() in SQL 7 and up to get a new GUID from SQL Server.
>>>
>>>TIA
>>
>>select sequencename.nextval from dual
>>
>>will return the next ID from the sequence into a VFP cursor. You can also create a remoter view based on this and just do a REQUERY() on the view when you need the next ID.
>
>Thanks!
>When I do that, does it increment it as well?

Yes
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform