sent

>Dorris,
>
>Your code does not make much sense to me. The schema and the data are both the same file
>[ the extension of a schema is normally .xsd ]
>
>
>Can you zip up both both the schema you posted yesterday and the xml file you're trying to load and email them to GregoryAdam at hotmail com ?
>
>I'll see what I can do - dunno whether I'll succeed though
>
>
>
>
>>That worked but as that xml had no data in it, I switched to one that does. It's a basic Decode table.
>>
>>This code works, except that I end up with 2 fields and no data rows
>>
>>

>>
>>LOCAL oxml as XMLAdapter
>>oxml = NEWOBJECT("xmladapter")
>>oxml.XMLSchemaLocation = 'c:\cmbhs\caredecodetables.xml'
>>oxml.LoadXML("c:\cmbhs\CareDecodetables.xml",.t.,.t.)
>>?oXML.Tables.Item(1).Fields.Item(1).DataType	&& returns 'M'
>>?oxml.Tables.Count		&& returns 1
>>oxml.tables.Item(1).tocursor	&& creates cursor named 'cmbhscodetables'
>>
>>

>>
>>here is the first part of the xml
>>
>>

>><?xml version="1.0"?><xs:schema targetNamespace="http://CMBHSSchemas.MHCenter.CareDecodeTables" 
>>      xmlns="http://CMBHSSchemas.MHCenter.CareDecodeTables" 
>>  xmlns:b="http://schemas.microsoft.com/BizTalk/2003" 
>>  xmlns:xs="http://www.w3.org/2001/XMLSchema">
>>  <xs:element name="CMBHSCodeTables">
>>    <xs:complexType>
>>      <xs:sequence>
>>        <xs:element name="texas_zipcode" type="texas_zipcode"/>
>>        <xs:element name="presenting_problem" type="presenting_problem"/>
>>      </xs:sequence>
>>    </xs:complexType>
>>  </xs:element>
>>
>>  <xs:simpleType name="presenting_problem">
>>    <xs:restriction base="xs:string">
>>      <xs:enumeration value="1"/>
>>      <!-- 1 MH (Mental Health) -->
>>      <xs:enumeration value="2"/>
>>      <!-- 2 MR (Mental Retardation) -->
>>      <xs:enumeration value="3"/>
>>      <!-- 3 ECI/DD (Early Childhood Intervention/Developmentally Delayed)-->
>>      <xs:enumeration value="4"/>
>>      <!-- 4 SA (Substance Abuse) -->
>>      <xs:enumeration value="5"/>
>>      <!-- 5 Related Condition - MR -->
>>    </xs:restriction>
>>  </xs:simpleType>
>>  <xs:simpleType name="texas_zipcode">
>>    <xs:restriction base="xs:string">
>>  <xs:enumeration value="75973"/>
>>  <xs:enumeration value="75973"/>
>>
>>

>>
>>I figure you didn't want to see a million lines of Texas' zipcodes
>>
>>Question is, how do I get the data to load? Am I incorrect in expecting the LoadXML to do it all in one pass?
>>
>>
>>
>>>>ok, using the minimal code from their examples
>>>>
>>>>

>>>>LOCAL oxml as XMLAdapter
>>>>oxml = NEWOBJECT("xmladapter")
>>>>oxml.LoadXML("c:\cmbhs\cmbhsadultuniformassessment.xml")
>>>>?oXMLAdapter.Tables.Item(1).Fields.Item(1).DataType
>>>>

>>>>
>>>>It still fails on the "c:references tag"
>>>>
>>>>
>>>
>>>
>>>Dorris,
>>>
>>>If the file you posted earlier is the schema
>>>
>>>try the following
>>>
>>>if it does not work, post the contents of c:\cmbhs\cmbhsadultuniformassessment.xml
>>>
>>>

>>>>LOCAL oxml as XMLAdapter
>>>>oxml = NEWOBJECT("xmladapter")
>>>
>>>oxml.XMLSchemaLocation = 'The file you posted earlier'
>>>
>>>
>>>>oxml.LoadXML("c:\cmbhs\cmbhsadultuniformassessment.xml", .t., .t.)
>>>>?oxml .Tables.Item(1).Fields.Item(1).DataType
>>>