Can you call a VFP SP from ASP? The SP may return the GetAutoIncValue().

Or do two commands at once
insert into ... select GetAutoIncValue() as myNewID from myTable where 1=0


>Thanks Sergey -
>There may be a kernal of possibility there but I am at a loss as to how to capture that into an ASP page. It would be easy enough in the VFP environment but I'm just not experienced enough with the web stuff to know even how to approach it. Is it even possible?
>
>
>>See GETAUTOINCVALUE() function.
>>
>>>Suppose you are accessing a VFP database via an ASP webpage. The table uses an autoinc integer field as the key field. You insert a new record using
>>>

>>>< %
>>>oRS.addnew
>>>% >
>>>

>>>
>>>is there a way to query the value in this new record's autoinc field other than reissuing the select and oRS.movelast to get the new record?
>>>
>>>Thanks