Problems with XML data source

[paolo70]

Hi,

i'm working with CR Professional 8.5.
I need to read data from a XML file that is not RAW, ADO, Data Island...

The format is the following:
<?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; ?>
<!DOCTYPE database SYSTEM &quot;..\..\..\te_repository\database.dtd&quot;>
<!-- time and expenses database table -->
<!-- last update: [Tue Mar 12 09:53:37 CET 2002] -->
<!-- by user: [d023066] -->
<!-- release: [2001/10/31 v1.00] -->
<database name=&quot;tande&quot;>
<table name=&quot;TRAVEL_COUNTRIES&quot;>
<row>
<field name=&quot;COUNTRY&quot;>AD</field>
<field name=&quot;COUNTRYTXT&quot;>Andorra</field>
</row>
<row>
<field name=&quot;COUNTRY&quot;>AE</field>
<field name=&quot;COUNTRYTXT&quot;>United Arab Emirates</field>
</row>
<row>
<field name=&quot;COUNTRY&quot;>AE</field>
<field name=&quot;REGION&quot;>DUBAI</field>
<field name=&quot;COUNTRYTXT&quot;>United Arab Emirate,Dubai</field>
</row>
</table>
</database>

I used the CR XML v3.6 driver and tried with Table/Row hints to get the data I need (...I need to rebuilt the table!!). The problem is that I cannot distinguish, into ROW tag, between the different FIELD tags. So when the query is fired, only data from FIELD &quot;COUNTRY&quot; will be retrived.

I know that this is a stupid question (sorry but I'm working with CR since yesterday), but I absolutely need to import that file in CR...

Could anyone help me??
Thanks a lot.