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
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.