Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLAdapter and Lead spaces.
Message
From
26/09/2005 10:55:13
 
 
To
26/09/2005 09:52:11
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01052997
Message ID:
01053064
Views:
14
Hi Devid,
Solution is good. But.. there lot of string fields.. some is empty.. and size of file is not good if this option apply for each field.
I had play with XMLField and try change .IsBase64 and .IsBinary for field.. then run .ToXML().
When both .t. - then in the XML appears base64 encoded string. but back convertion is impossible. It call error "Function, argument or type is invalid".
If .NoCpTrans=.t. and .IsBase64=.t. - it leave value as is (trim and not encoded)
If .IsBinary = .t. and .IsBase64=.t. - it encode string, but no back convertion possible

Ok. Finaly question.
Is there option for single field to preserve white space?

Thanks
Denis

>Denis,
>
>>I have problem with XMLAdapter and field which begins from SPACE(1) (for example " Denis")... Then I open XML File.. and in my XML - No spaces before.. seems AddTableSchema Trimming string fields. When I convert XML back to cursor.. all lead spaces losted. Any solution, how to avoid trim of string field?
>
>This might solve your problem:
loXMLAdapter.PreserveWhiteSpace = .T.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform