Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Add memo field to cursor
Message
De
25/09/2007 13:56:13
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Add memo field to cursor
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01256737
Message ID:
01256737
Vues:
64
I have a cursor created via
SELECT fieldlist FROM myTable WHERE conditions INTO CURSOR myCursor READWRITE
I would like to add a memo field to myCursor but haven't quite figured out the syntax for either ALTER TABLE myCursor (Invalid Operation) or modifying the SELECT statement.

Is there something cleaner than
SELECT fieldlist FROM myTable WHERE conditions INTO TABLE myTmpTable
ALTER TABLE myTmpTable ADD newmemofield M
SELECT * FROM myTmpTable INTO CURSOR myCursor READWRITE
DELETE FILE myTmpTable.*
Thanks.........Rich
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform