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?
--sb--