Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1115 when altering cursor
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01431766
Message ID:
01431774
Views:
50
ALTER TABLE will not work on a cursor when field names are longer than 10 characters because it creates a free table as intermediate step.

>I had a piece of code where I was simply creating a cursor from an array. Then, I used Alter Table. It used to work very well. Now, I made some changes to the original table. I get the error 1115 (Invalid operation on the cursor) on every alter table line that I have. That error states that VFP is trying to do a PACK and cannot do it.
>
>My field names are unique (not already in the table) and are not too long. Also, the cursor is normally created without any problem
>
>I can't find what can be wrong all of a sudden.
>
>Thank you for you help!
>
>Normand Savage
>ICX Informatique
>
>
>SELECT prospect 
>
>AFIELDS(aTemp,"PROSPECT")
>
>CREATE CURSOR curRapport2 FROM ARRAY aTemp
>ALTER table curRapport2 alter COLUMN nofiche I
>ALTER table curRapport2 ADD COLUMN nomMarche C(25)
>ALTER table curRapport2 ADD COLUMN nomProprio C(35)
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform