Thread: table_to_xml command isn't working

Hello,

I have registered an odbc entry (named xfpdb) on my Windows XP Pro machine using PosgreSQL Ansi vers. 8.02.05 (my db server is 8.3 beta 1).

Using a simple VB 6.0 code, I have tried to connect to it and return some XML information using ADO as in the following:

    ….

    cn.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=xfpdb"

    rs.Open "select * from table_to_xml('""Versions""', true, true, '')", cn

    MsgBox rs.Fields(0).Value

    ……

The returned XML string appears truncated, as shown below:

-------------------------------------------------------------------------------------------------------

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <Version_Id>962</Version_Id>

  <Version>0.0.0.0</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:28.20</CreatedDateTime>

</Versions>

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <Version_Id>963</Version_Id>

  <Version>0.0.0.1</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <Version_Id>964</Version_Id>

  <Version>0.0.0.2</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <Version_Id>965</Version_Id>

  <Version>0.0.0.3</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</C                    @ 

-------------------------------------------------------------------------------------------------------

Same result using Labview 8.2.1 and its database connectivity tool.

But if I try to execute the query directly using pg Admin III, the XML output is correct, as shown below:

-------------------------------------------------------------------------------------------------------

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <Version_Id>962</Version_Id>

  <Version>0.0.0.0</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:28.20</CreatedDateTime>

</Versions>

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <Version_Id>963</Version_Id>

  <Version>0.0.0.1</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <Version_Id>964</Version_Id>

  <Version>0.0.0.2</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <Version_Id>965</Version_Id>

  <Version>0.0.0.3</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

-------------------------------------------------------------------------------------------------------

Can anyone help me?

Thanks in advance,

Luigi