Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Storing NULL values in XML
Message
De
12/12/2009 11:50:37
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Divers
Thread ID:
01438743
Message ID:
01438760
Vues:
49
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform