Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add column to a cursor
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01664052
Message ID:
01664063
Views:
51
>>Hi,
>>
>>Is there a trick to be able to add a column to a cursor created with XMLTOCURSOR()? I pass the following parameters to the XMLTOCURSOR():
>>512+8192
>>
>>And then if you call ALTER TABLE ADD COLUMN CoName C(10), you get the error "Invalid operation on the cursor".
>>
>>Can I change anything in the parameter to XMLTOCURSOR() to all adding a column?
>>
>>TIA
>
>If you can not add it to cursor before XMLTOCURSOR() then:
>
>XMLTOCURSOR() && Get the cursor here. Lets say it is called crsTest
>
>SELECT *, CAST("" as C(10)) AS CoName FROM crsTest INTO CURSOR crsTest READWRITE
>
Thank you!
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform