?VARTYPE(dossiersnew.u_glnentr),VARTYPE(dossiersnew.qtt),>looks like the fields get translated to something different then character.
><?xml version="1.0" encoding="iso-8859-1"?> ><xml> > <item> > <bostamp>Adm22020730717,977000001</bostamp> > <bistamp>Adm22020730718,046000002</bistamp> > <ref>DIFGB2L</ref> > <qtt>1.0000</qtt> > <lote/> > <obrano>36</obrano> > <design>PC Gold&Blue Porcelain 2L Diffuser Bottle (Empty) </design> > <lordem>10000</lordem> > <u_glnentr>5600000025888</u_glnentr> > <dataobra>2022-02-05 00:00:00.000</dataobra> > </item> >>
clear TEXT TO lcXML noshow <?xml version="1.0" encoding="iso-8859-1"?> <xml> <item> <bostamp>Adm22020730717,977000001</bostamp> <bistamp>Adm22020730718,046000002</bistamp> <ref>DIFGB2L</ref> <qtt>1.0000</qtt> <lote/> <obrano>36</obrano> <design>PC Gold&Blue Porcelain 2L Diffuser Bottle (Empty) </design> <lordem>10000</lordem> <u_glnentr>5600000025888</u_glnentr> <dataobra>2022-02-05 00:00:00.000</dataobra> </item> </xml> ENDTEXT &&lcXML CREATE CURSOR dossiersnew (; bostamp c(25),; bistamp c(25),; ref c(10),; qtt n(20,5),; lote c(10),; obrano c(10),; design c(120),; lordem c(20),; u_glnentr c(15),; dataobra T) XMLTOCURSOR(m.lcXML,'dossiersnew',8192)or. with more control like
clear TEXT TO lcXML noshow <?xml version="1.0" encoding="iso-8859-1"?> <xml> <item> <bostamp>Adm22020730717,977000001</bostamp> <bistamp>Adm22020730718,046000002</bistamp> <ref>DIFGB2L</ref> <qtt>1.0000</qtt> <lote/> <obrano>36</obrano> <design>PC Gold&Blue Porcelain 2L Diffuser Bottle (Empty) </design> <lordem>10000</lordem> <u_glnentr>5600000025888</u_glnentr> <dataobra>2022-02-05 00:00:00.000</dataobra> </item> </xml> ENDTEXT &&lcXML CREATE CURSOR dossiersnew (; bostamp c(50),; bistamp c(50),; ref c(50),; qtt c(50),; lote c(50),; obrano c(50),; design c(50),; lordem c(50),; u_glnentr c(50),; dataobra c(50),; ; nqty n(20,5),; tdataobra T) XMLTOCURSOR(m.lcXML,'dossiersnew',8192) REPLACE ALL; nqty with VAL(qtt),; tdataobra with DATETIME(; VAL(getwordnum(STREXTRACT(dataobra,'',' ',1),1,'-')),; VAL(getwordnum(STREXTRACT(dataobra,'',' ',1),2,'-')),; VAL(getwordnum(STREXTRACT(dataobra,'',' ',1),3,'-')),; VAL(getwordnum(STREXTRACT(dataobra,' ','',1),3,':')),; VAL(getwordnum(STREXTRACT(dataobra,' ','',1),3,':')),; VAL(getwordnum(STREXTRACT(dataobra,' ','',1),3,':'))) *proceed like your old codeHi Lutz,