Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid operation for the cursor
Message
 
 
À
28/02/2007 22:09:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01199867
Message ID:
01199869
Vues:
13
This message has been marked as the solution to the initial question of the thread.
>Greetings all
>I have been using the ALTER TABLE command on a cursor for months with no problems. Tonight, for NO reason, I get an "Invalid operation for the cursor". The ALTER TABLE command line is the bad player. When help is clicked, it indicates error 1115 was thrown "An attempt was made to use the PACK command on a cursor". No pack command is used. Here is the code:
>
>SELECT (poItems.ponum + STR(poItems.poLine)) as poNumLine,;
>        poItems.*, apInvMast.invPK as invPK;
>   FROM poItems;
>   WHERE poItems.poNum = parPONum AND EMPTY(poItems.invNum);
>   INTO CURSOR curDummy readWrite
>ALTER TABLE curDummy ADD COLUMN miscDesc M null
>
>Completely clueless. Any clues to be found in the community?
>
>Vnce

Do you have a field with more than 10 chars long in the select statement? If yes, then this is a problem. It was discussed here several times already, do you want relevant threads?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform