Thanks, Sergey. Exactly what I was looking for after finding out I need to create a different stored procedure.
Thanks again,
James
>Take a look at article 'Using ADO and Visual FoxPro 6.0 to Access SQL Server 7.0 for Primary Key Generation' at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxtk00/html/ft00l1.asp>
>>Hi,
>>
>>I'm using ADO 2.6 from within VFP6 SP5 and am having a problem getting a record set to be returned from an ADO command object when executing a stored procedure on SQL Server 7. Here is my code:
>>
>< SNIP >