Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get next sequence from Oracle
Message
From
19/01/2001 18:02:14
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00465909
Message ID:
00466062
Views:
13
>>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?
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform