Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to maintain data types
Message
From
03/01/2003 11:13:02
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
03/01/2003 11:01:44
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00737691
Message ID:
00737703
Views:
22
>I am just starting to play with XML.. what im doing is this
>SELECT * from c:\acsource\data\employee WHERE em_id = '0000001' INTO CURSOR q1
>CURSORTOXML('q1','lcfile',2,0,0)
>XMLTOCURSOR(lcfile,'q2',0)
>sele q2
>scatter memvar
>insert into c:\temp\employee from memvar
>
>the problem in i get an operater operand type mismatch
>
>What it is doing is taking char fields that have numeric values like em_id above and making them numeric in the XML
>
>any help would be appreciated.

CURSORTOXML('q1','lcfile',2,0,0,"1")
Would add inline schema.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform