Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Edit SQL table Structure in VFP
Message
From
01/01/1999 00:19:13
Brian Lee
World Access Network, Inc.
Vancouver, Washington, United States
 
 
To
28/12/1998 01:54:27
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00170666
Message ID:
00172043
Views:
28
>Anyone knows is there a way to edit/modify Table Structure
>in VFP environment once the database is upsized to
>MS SQL 6.5? Thanks!

SQLExec() passes an SQL statement directly to the back-end server. I haven't tried it with ALTER TABLE, but don't see why this wouldn't work. Another option would be to write the modification as a stored procedure on SQL 6.5, even parameterized if you wish, then call it from VFP with SQLExec(sp_your_proc). Depends in what ways you are modifying the table, and why.

Brian Lee
World Access Network, Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform