>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