Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Storing NULL values in XML
Message
From
12/12/2009 11:50:37
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
01438743
Message ID:
01438760
Views:
48
Thank you so much. My problem appears to be how I was creating the cursor.

CREATE CURSOR Test (PK I, txt C(20) NULL, val1 I NULL, dt D NULL)
INSERT INTO Test VALUES (1, "One", 1, DATE())
INSERT INTO Test VALUES (2, "Two", 2, NULL)
INSERT INTO Test VALUES (3, "Three", NULL, NULL)
INSERT INTO Test VALUES (4, "Four", NULL, DATE())
CURSORTOXML(0, "Test1.xml", 1,512,0)

CREATE CURSOR NG (PK I, txt C(20) DEFAULT NULL, val1 I DEFAULT NULL, dt D DEFAULT NULL) && Doesn't work
XMLTOCURSOR("Test1.xml", "ng", 8912)
BROWSE nowait
SELECT 0
CREATE CURSOR OK (PK I, txt C(20) NULL, val1 I NULL, dt D NULL) && works
XMLTOCURSOR("Test1.xml", "ok", 8912)
BROWSE nowait
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform