>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()
SELECT *, CAST("" as C(10)) AS CoName FROM crsTest INTO CURSOR crsTest READWRITE
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.