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