Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to run an sql script file?
Message
From
21/05/2001 11:03:06
 
 
To
19/05/2001 22:41:05
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00509146
Message ID:
00509470
Views:
15
I want to run SQL DDL statements over a VFP database, not a ODBC database, I mean, create tables in VFP using DDL statements like create table, alter table, add column, create index etc.

If I try to execute this statement in the command window:
alter table MyTable add primary key (Field1, Field2, Field3)
I get an error:
Function name is missing ).

I was wandering too, if I can execute a complete sql script, instead line by line. Something like Oracle instruction @c:\script.sql

Thanks.
glurrea
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform