Use the SQL Profiler to verify that the command is coming across correctly. There's no reason that you can create a stored procedure in this fashion.
-Mike
>I have a VFP application that creates SQL Server databases and tables on the fly. I would also like to be able to create a stored procedure in the created database (this database is usually not the default database).
>
>I created a table in SQL that contains the stored procedure name and stored procedure code
>
>
>lcSql='Create proc '+ALLTRIM(sqltable.csp_name)+" "
>lcscript=ALLTRIM(sqltable.CSP_SCRIPT)
>lcscript=STRTRAN(lcscript,'lcdatabase',gccurrentjob)
>lcsql=lcsql+lcscript
>
>lnSQLResult = SQLEXEC(gnConnectHandle,lcsql)
>
>SQL acts like the command was successful but the stored procedure is not created.
>
>
>Any suggestions??
>
>Thanks.
>
>Joyce