Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Edit SQL table Structure in VFP
Message
De
01/01/1999 00:19:13
Brian Lee
World Access Network, Inc.
Vancouver, Washington, États-Unis
 
 
À
28/12/1998 01:54:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00170666
Message ID:
00172043
Vues:
29
>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
Fil
Voir

Click here to load this message in the networking platform