Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid operation for the cursor
Message
 
 
To
28/02/2007 22:09:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01199867
Message ID:
01199869
Views:
14
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform