nResult = SQLEXEC(iConnHandle, "EXEC gen_new_id ?@nKey")

>Ok, I have the SP correct now.
>
>Here's my code. SQL is returning 'Incorrect syntax near 'gen_new_id'.'
>
>

>sSqlConnStr = "DRIVER=SQL Server;SERVER=dserver3;database=newmegadb;uid=sa;password="
>
>iConnHandle = SQLSTRINGCONNECT(sSqlConnStr)
>
>IF iConnHandle > 0
>
>  nKey = 0
>  nResult = SQLEXEC(iConnHandle, "gen_new_id ?@nKey")
>
>  IF nResult < 0
>    AERROR(aErrInfo)
>    MESSAGEBOX(aErrInfo[2])
>  ELSE
>    ? nKey
>  ENDIF
>
>SQLDISCONNECT(iConnHandle)
>
>ELSE
>	? "Not connected"
>ENDIF
>

>