Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Altering the structure of a cursor
Message
De
04/01/2008 17:33:31
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Altering the structure of a cursor
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01279520
Message ID:
01279520
Vues:
70
What would prevent me from altering the structure of a readwrite cursor?

In two different locations in my application, I am creating a readwrite cursor and then dropping the memo fields because I later want to do a union and you can't union cursors with memo fields.

I know several work arounds, but I am puzzled since dropping a field works fine in one instance and is failing in another.

So here is some sample code:
* mhistory here is the memo field
select cfirst, clast, mhistory ;
 from customer ;
 where clast = "Brown" ;
 into cursor cur_selectedcustomers ;
 readwrite

alter table cur_selectedcustomers drop column mhistory
The error I am getting is: Invalid operation for the cursor (Error 1115)

Which from the VFP help is: An attempt was made to use the PACK command on a cursor.
Carole Shaw
Fred Hutchinson Cancer Research Center

Eagles may soar, but weasels don't get sucked into jet engines.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform