Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Altering the structure of a cursor
Message
 
 
À
04/01/2008 17:33:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
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:
01279522
Vues:
13
You cannot ALTER cursor with long filed name (longer than 10 characters). You can UNION cursors with memo fields if you can use UNION ALL.

>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.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform