>Hi all
>
>i have the following xml that i put in a string variable :
>

> <?xml version="1.0" encoding="iso-8859-1" standalone="yes" ?> 
>- <SMS>
> <ID>00000036</ID> 
> <CONTENT>bert x1</CONTENT> 
> <RECIPIENT>+32475227556</RECIPIENT> 
> <SENDER>+32499978283</SENDER> 
> <SMSPORT>SYSTEMAT</SMSPORT> 
> <SMSID>0</SMSID> 
> <SYNSMSID>00000036</SYNSMSID> 
>  <STATUS>1</STATUS> 
> <SCSTAMP>2009030416:25540000</SCSTAMP> 
> <STAMP>2009030416:25540000</STAMP> 
> </SMS>
>

>
>step 1 : i create a cursor like this :
>CREATE CURSOR qrysms(ID c(8),content c(50),recepient c(50),sender c(50),smsport c(50),smsid c(10), synsmsid c(8),status n(2),scstamp c(50),stamp c(50))
>
>step 2
>i try to put the xml in my cursor
>XMLTOCURSOR(lcXml,'qrysms',8192)
>
>result :
>i get an empty line in my qrysms.
>
>does somebody knows whey the xmltocursor adds an empty line in stead of a line with data ?
>
>thnx

It has a single SMS record but missing 'table'.

Xmltocursor(Strtran(Strtran(m.lcXML, ;
  '<SMS>','<data><SMS>'),;
  '</SMS>','</SMS></data>'),;
  'qrysms',8192)

Cetin