General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only