Hi Guys,
I want to create a program that will convert a cursor into an xml file and later use that xml file to retrieve the data stored in it. I created the following cursor
CREATE CURSOR mycur (pono c(10), order I(4))
I then populated this cursor with the following records
1000 0
1001 1
1002 1
I then converted this cursor to xml using the following lines of code
CURSORTOXML("mycur","lcXML",1,48)
STRTOFILE(lcXML,"c:\mycur1.xml")
when its time for me to use the xml file and convert it back into a cursor I used the following lines of code
XMLTOCURSOR("c:\mycur1.xml","newcur",4)
The main problem is that the data type for the field pono has changed to Integer and the field for order has changed to L(1) or logical. Is there a way to retain the original field types of the original cursor which in this case is mycur? I am expecting that when I convert the xml file back to cursor using this line of code, XMLTOCURSOR("c:\mycur1.xml","newcur",4) it will create a new cursor with an alias of newcur having the same fields and data type as mycur.
Please help and thanks in advance...
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.