Execute sql script from Vfp

[dotnik]

Good morning,
Can I execute a file script generate from Sql Server 2000 with all istruction necessary for create database, create table, index and rules during the setup of my application?
I've creating an application that will be setup on my customer with MSDE.
I should be to create a setup program that read from sql script file and execute with SQLEXEC(..) sql command.
Best regard, and good year to all.

Nicola
Ferrandina (MT) - Italy

 

[bborissov]

SQLEXEC(connHandle,[EXEC ]+FILETOSTR("MySqlScript.SQL"))

Just be sure you didn't have any
GO commands in the script file.

Borislav Borissov