table_to_xml command isn't working

["Luigi Pirillo" <luigi(dot)pirillo(at)sky-team(dot)it>]

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