Hi Everybody, I'm using the functions XMLToCursor() y CursorToXML() to generate a COM Component, but I found a little problem with them:
CREATE CURSOR Foo (LeadingZero c(13))
INSERT INTO Foo VALUES('0090810490000')
INSERT INTO Foo VALUES ('0010200520001')
?VARTYPE(foo.leadingzero)
CursortoXML("Foo","lcXMLData")
USE IN "Foo"
XMLtoCursor(lcXMLData,"NewFoo")
?VARTYPE(newfoo.leadingzero)
*** As u can see, the LeadingZero field now is a Numeric type.
I can use PADL() to get back the field as a string (keeping the leading zeros), but I think there shoud be another way to get what I want, wich is, no conversion in field types. My question is: What am I doing wrong?,