I am calling a stored procedure from VFP.

sqlexec(nHandle, "{Call sp_GetNewKey}","nextid")
thisform.txtInvoice.value = nextid.newid


CREATE PROCEDURE sp_GetNewKey
AS

SELECT newid = @@identity
GO


How do I tell the stored procedure what table it is using? And to operate on insert?

Thank you.