>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement