Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLTOCURSOR
Message
 
 
To
04/02/2009 05:22:04
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01379141
Message ID:
01379144
Views:
37
W/o XML schema, the XMLTOCURSOR() guesses the type of fields in the cursor created based on data in the XML file. If data is only 1/0 it consider it logical .T./.F.. You have 2 choises:
- Create a cursor beforehand and tell XMLTOCURSOR() to use it (nFlag = 8192)
- Provide XML schema and point to it by modifying XML before conversion. It would be easier too implement with XmlAdapter because you can point to the XML schema w/o need to modify XML itself.

>
>i have an apllication that gets an xlm from a remotedatabase.
>
>with "lnQtyReturn=XMLTOCURSOR(loXmlFile,'QryDierInfo')" i convert the xml to a cursor.
>
>when i look in the xml i have a field that contains the value 1.
>
>with xmltocursor the 1 is converted to .T. what gives an error in my code because the program expects a value and not a logical.
>
>Does somebody has an idea the resolve this problem ?
>
>thnx
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform