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.