Hi!

No. The {} is a command for ODBC, not for SQL Server. Script works on SQL Server, so you will have no ODBC there ;)

SQL Server have its own way o call SP:

declarer @ID integer
EXEC generate_pk("mytablename",@ID)

HTH.


>I am running a small application that generates a script file that will be run in SQL Server 7. For the most part the script file is a series Insert, Update and Delete statements. To generate the script file I evaluate a VFP string with variables then stuff a line into the script file with the evaluated string.
>
>I now need to also execute a stored procedure from within this script file and have never done this before. The stored procedure I need to execute returns a primary key that is then used later to generate another script line. To execute the stored procedure from within VFP the command line is
>
>SQLExec(lnHandle, "{call generate_pk("mytablename",?@lcid)}", "c_temp")
>
>where "mytablename" is the name of the table and lcid is the pk value to be returned. Will this same syntax work when executed from a script file?
>
>Thanks in advance for any advice you can provide!
>
>Margaret