>Hi,
>
>This is a very basic question, but I can't find the answer.
>
>How can a run a SQL script (myscript.sql) eiwhout using the SQL query analyser tool, ideally form a foxpro program.
>
>I tried this:
>sqlexec(nConn, "v:\dirname\myscript.sql")
>
>It did not return any error but it did not execute either.
>
In VFP6, you might try:
LOCAL cSQLStatement
cSQLStatement=FILETOSTR("v:\dirname\myscript.sql")
SQLEXEC(nConn,cSQLStatement)