>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only