>I was wandering if I can run an sql script file into VFP. I have an sql script file for to create a database, (create table.......,etc.). Sql statements in the file are SQL ANSI-92 compliant. Is there any way for to do that???
You can use SQL Pass-Through in VFP like so:
nHandle = SQLCONNECT("Pubs") && use DSN or OleDB connect stringSQLEXEC(nHandle,"create table MyTable (MyFirstField char (20))")
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry