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.