Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter cursor
Message
From
18/05/2008 15:03:25
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01317984
Message ID:
01317989
Views:
7
I have changed all fields to be less or equal 10 chars. But the command still does not work.

>Yes if you make field names in a cursor less or equal 10 characters than you can apply ALTER TABLE.
>
>>So, if I make all fields less then 11 chars it would work?
>>
>>>The ALTER TABLE command is not supported on cursors with long field names (longer that 10 characters).
>>>
>>>>I am trying to ALTER a cursor that has a logical field to numeric. The cursor is readwrite. When I issue:
>>>>ALTER TABLE cursorname ALTER COLUMN fieldname I
>>>>then I am getting "Invalid operation for the cursor".
>>>>But if I browse that cursor, then go to Properties and manually change one of the fields type, then after this I can run my command with no problem. Why it is working that way?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform