Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALTER TABLE on SPT Created Cursor..
Message
De
06/08/2002 04:00:40
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
ALTER TABLE on SPT Created Cursor..
Divers
Thread ID:
00686490
Message ID:
00686490
Vues:
85
On the following code example in VFP7...

SQLEXEC(h,'select * from ARTICLE',"XXX")
ALTER TABLE XXX ADD &cPicGname g(4)

I get "Function is not supported on remote tables (Error 1525)"

What's the easiest way to add the column to the table?
Note that I have an additional consideration in that I may need
to add one to ten columns and the cursor could sometimes be very large
so a select is not the best.

I was hoping for something like:
USE DBF("XXX") AGAIN IN 0 ALIAS yyy
ALTER TABLE yyy ADD &cPicGname g(4)


BR
Tim
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform