Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorToXML, XMLToCursor and XMLAdapter
Message
From
12/05/2006 16:52:43
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
12/05/2006 16:43:59
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01121251
Message ID:
01121498
Views:
12
>>That way you still pass a single string, and everything's in it. The cXml field would have to be a binary memo, AFAIK. I've done something like this for (believe it or not) backup.
>
>I like that approach. What is a "binary memo" compared to the usual kind?

That's the one where you add the "nocptrans" clause in the Create Table/Cursor command. Or you select memo(binary) in Modify Table.

Basically, tells VFP not to even try to convert its content based on codepage, but to take it as-is, byte for byte. In VFP7, when I was doing this, the memos would occasionally give me problems when reverting from xml to cursor unless they were binary. Probably builds the [Cdata...] thing as base64 instead of UTF-8 text or something like that. I've also done it in VFP8, and the cursor definition went something like

Create Cursor notes (eventpk i, sort1 c(30), sort2 c(30), ;
cDate c(25), ctitle c(120) NOCPTRANS, cArtist c(60) NOCPTRANS, ;
TYPE_FK I NOT NULL, ;

etc etc (no more memos there).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform