Further, I believe that, by default, 0 and 1 are treated as Boolean. Laurie
On 21 July 2016 at 12:01, Laurie Alvey <[email protected]> wrote: > When you issue the CursortoXML() use this: > > CursorToXML("curSource","lcXML", 1, 0, 0, "1") > > The final parameter creates an inline schema so that XMLtoCursor knows > what the column types are. > > Laurie > > On 21 July 2016 at 11:50, Paul Newton <[email protected]> wrote: > >> Hi all >> >> I came across some unusual behaviour with XMLToCursor which the following >> code clearly demonstrates: >> >> Local lcXML >> Create Cursor curSource (A N(1), B N(1), C N(1)) >> Insert Into curSource Values(0,1,2) >> CursorToXML("curSource","lcXML") >> Browse Nowait >> XMLToCursor(lcXML,"curTarget") >> Browse Nowait >> >> lcXML looks like this: >> <?xml version = "1.0" encoding="Windows-1252" standalone="yes"?> >> <VFPData> >> <cursource> >> <a>0</a> >> <b>1</b> >> <c>2</c> >> </cursource> >> </VFPData> >> >> In curTarget fields A and B are logical. Can anybody throw any light on >> this, particularly how the XML should be constructed so as to ensure that >> fields A and B are created as type numeric? >> >> Many thanks >> >> Paul Newton >> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/camvtr9dnackpk4-atoimb0j8s46b_izc-3arjokuggyi3tb...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
