This will store the XML string into a variable lcFile with data types.
CURSORTOXML('q1','lcfile',1,0,0,'1')
HTH.
>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.