Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with xml
Message
From
13/02/2007 05:13:17
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
13/02/2007 03:50:30
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Germany
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01194974
Message ID:
01194992
Views:
20
>Hello Everybody !
>I have to read xml files from our customer into a foxpro cursor!
>The first line looks like this:
>?xml version="1.0" encoding="ISO-8859-1" standalone="yes" ?
>When i do:
>XMLTOCURSOR("2003667011.xml","mycursor")
>
>I get the following error:
>XML-parsererror: Invalid at the top level of the document
>line 1, position 1. 2003667011.xml
>
>I tried to copy the content of the file(only 20 lines) into this message, but got an explorer error:
>You cannot include a style attribute inside a tag ???
>Therefore i take out the leading < and closing > from the first line
>
>What do i miss
>Any help welcomed
>
>best regards
>Albert

Albert,
XMLTOCURSOR("2003667011.xml","mycursor",512)
Otherwise you're saying first parameter is an expression or a memory variable holding xml content. ie:
XMLTOCURSOR(;
 '<myData>'+;
 ' <myRow firstName="Albert" lastName="Beermann"/>'+;
 ' <myRow firstName="Cetin" lastName="Basoz"/>'+;
 '</myData>',"mycursor")
or:
cMyXML = FileToStr("2003667011.xml")
XMLTOCURSOR(m.cMyXML,"mycursor")
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
Next
Reply
Map
View

Click here to load this message in the networking platform