Message
De
12/01/2017 02:31:37
À
11/01/2017 17:22:29
Divers
Thread ID:
01646543
Message ID:
01646556
Vues:
65
>UPDATE. I found the cause of the problem. When the column name is greater than 10 characters, you cannot change it. Strange though that VFP allows creating a cursor with a column with the name greater than 10 char, but won't allow to change the name.
>
>Hi,
>
>I want to change a cursor column name. When I do it in the Command window, it works. Here is the code:
>
>
>But when I have pretty much the same code in the .PRG of the program, I get error:
>
>Could someone explain why? TIA
How did you create the cursor?
>
>Hi,
>
>I want to change a cursor column name. When I do it in the Command window, it works. Here is the code:
>
>cCursorName = "MyCursor" >cFieldFrom = "FieldName1" >cFieldTo = "FieldName2" >alter table (cCursorName) rename (cFieldFrom) to (cFieldTo) >>So the above works without a problem in the Command window.
>
>But when I have pretty much the same code in the .PRG of the program, I get error:
>
>Error 1115 >Invalid Operation for the Cursor >>
>Could someone explain why? TIA
How did you create the cursor?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
The only thing normal about database guys is their tables.