Your XML is missing XML schema. W/o it XMLTOCURSOR() has to make some assumptions about field types in the resulting cursor. If there are only 1 and 0 in any element, it'll be assumed to be logical in the cursor

>Anyone can explain why I am getting a different result using the following expression:
>
>

>cFileName = "test.xml"
>XMLTOCURSOR(cFileName,"alias_name", 512)
>

>
>The content of text.xml looks like following:
>

><DataBase>
> <ConnectionInfo>
>  <DBKey>1</DBKey>
>  <String>SQLNCLI10</String> 
>  </ConnectionInfo>
> <ConnectionInfo>
>  <DBKey>2</DBKey>
>  <String>SQLNCLI10</String> 
>  </ConnectionInfo>
></DataBase>
>

>
>The above XML file produces a cursor with the column DBKey is number, 1 and 2. This is what I expect.
>
>But if I have only one element ConnectionInfo as following:
>

><DataBase>
> <ConnectionInfo>
>  <DBKey>1</DBKey>
>  <String>SQLNCLI10</String> 
>  </ConnectionInfo>
></DataBase>
>

>
>Then the above test.xml produces a cursor where the column DBKey is .T.
>
>Why? Could someone explain what I am missing?