>>>>Hi,
>>>>
>>>>Is it possible to load an XML file into XMLAdapter ignoring the .xsd file defined in the .XML file? For example, the top of the XML looks like this:
>>>>
>>>>
>>>><?xml version="1.0" encoding="utf-8" ?>
>>>><EmailList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>> xsi:noNamespaceSchemaLocation="EmailList.xsd" >
>>>>
>>>>
>>>>But I want to load the XML ignoring this EmailList.xsd because XML may have elements NOT defined in the XSD file. Can it be done?
>>>>
>>>>TIA
>>>
>>>Ignore inline or referenced schema:
>>>
>>>m.loXMLAdapter.XMLSchemaLocation = ""
>>>
>>
>>Thank you. But something does not work. I added this line in the following segment:
>>
>>
>>oXMLAdapter = NEWOBJECT('XMLAdapter')
>>oXMLadapter.XMLSchemaLocation = ""
>>oXMLadapter.LoadXML( "emaillist.xml", .T.)
>>oXMLadapter.Tables.Item(1).ToCursor(.F.,cCursorName)
>>
>>
>>but then I get error "Index or expression does not match an existing member of the collection"
>
>You said "ignore the schema". That lead VFP to be unable to create a table.
>
>
>oXMLadapter.LoadXML( "emaillist.xml", .T.)
>IF oXMLadapter.Tables.Count = 0
> MESSAGEBOX("No tables were created...")
>ELSE
> oXMLadapter.Tables.Item(1).ToCursor(.F.,cCursorName)
>ENDIF
>
>
>Can you provide a sample document with no sensitive information and describe what are you looking after?
I will provide an example. But what confused me is that if I don't provide the schema, I thought that XMLAdapter will still create a table based on the elements of the XML file. I see now that that does not work.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham