Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Storing NULL values in XML
Message
 
 
To
12/12/2009 11:50:37
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
01438743
Message ID:
01438765
Views:
51
You're welcome

>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
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform