Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid operation for the cursor
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01199867
Message ID:
01199873
Views:
13
>>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?

Looks like I'm very repetative Re: Help Adding Column to Cursor Thread #1173581 Message #1173583 <g>

And this Message #1173638 seems to be a solution.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform