>>>>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
Thanks again!
Insanity: Doing the same thing over and over and expecting different results.