Hi!
Well, you can make an output parameter for SP and use it to return the new ID number. However, what is bad with the cursor? The speed here is the same.
>Thanks Vlad !
>
>I knew this solution, but I imagined there was a solution where the returned parameters didn't had to be passed through a cursor ... but this seems to be the only way.
>
>
>>Hi!
>>
>>>>Return the ID value from there as you need, you can use also RETURN that is better for use in the SP.
>>>
>>>My quesion to this remark is, can read this parameter in Visual foxpro, and if yes, how ?
>>
>>When last statement is SELECT ... as nID:
>>
>>=SQLEXEC(nConnectHandle,"EXEC MyNewID 'MyTableName'",'IdResult')
>>? IdResult.nID
>>
>>HTH.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.