>I am just starting to play with XML.. what im doing is this
>SELECT * from c:\acsource\data\employee WHERE em_id = '0000001' INTO CURSOR q1
>CURSORTOXML('q1','lcfile',2,0,0)
>XMLTOCURSOR(lcfile,'q2',0)
>sele q2
>scatter memvar
>insert into c:\temp\employee from memvar
>
>the problem in i get an operater operand type mismatch
>
>What it is doing is taking char fields that have numeric values like em_id above and making them numeric in the XML
>
>any help would be appreciated.
CURSORTOXML('q1','lcfile',2,0,0,"1")
Would add inline schema.
Cetin