Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorToXML
Message
 
 
À
27/10/2008 19:35:13
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01357537
Message ID:
01357543
Vues:
53
This message has been marked as the solution to the initial question of the thread.
In order to correctly convert XML back to cursor, you've to include inline schema into generated XML
CREATE CURSOR XmlStore (pk I, xml M NOCPTRANS)

CREATE CURSOR Test (id  I, txt C(10), note M )
INSERT INTO Test VALUES (1, "One", "First Line")
INSERT INTO Test VALUES (2, "Two", "Second line")
INSERT INTO Test VALUES (3, "Three", "Third line")

lcXml = ""

CURSORTOXML(0, "lcXml",1,8,0,"1")

INSERT INTO XmlStore VALUES (1, lcXml)

XMLTOCURSOR(XmlStore.xml , "crsXml")

BROWSE LAST NOWAIT
>I would like to store a cursor to a memo (general?) field in a format (XML?) so I can recreate the cursor later. How can I do this? I've looked at CursorToXML and XMLToCursor, but it doesn't seem to do what I want. Or I don't know how to use it for this.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform