[ psqlodbc-Bugs-1000510 ] Access the rdoResultset´s column is NULL in the second access - Mailing list pgsql-odbc

From
Subject [ psqlodbc-Bugs-1000510 ] Access the rdoResultset´s column is NULL in the second access
Date
Msg-id 20060102190351.B963C1033DEF@pgfoundry.org
Whole thread Raw
List pgsql-odbc
Bugs item #1000510, was opened at 2005-12-27 16:20
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000510&group_id=1000125

Category: None
Group: None
>Status: Closed
>Resolution: Rejected
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Access the rdoResultset´s column is NULL in the second access

Initial Comment:
In VB's example:

Private Sub QueryTest()

Dim rdoQuery As rdoResultset

Set rdoQuery = InjetDB.OpenResultset("SELECT A || B AS Test FROM pdTable")

If not rdoQuery.EOF Then
    Debug.print(rdoQuery!Test)
    Debug.print(rdoQuery!Test) 'Error happen (Invalid use of NULL)
End If

End Sub


' rdoResultset is Microsoft Remote Data Object 2.0
' Postgree 8.1
' psqlodbc-8_01_0106

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

>Comment By: Ludek Finstrle (luf)
Date: 2006-01-02 20:03

Message:
User wrote:
The original posting has a bad assumption. The problem is not the ODBC driver.
When A or B is a NULL, then A || B concatenation returns NULL. The server returns NULL.

Running the a sample from psql, or pgadmin will verify this. It is even
clearer with a query like
SELECT A,B,A||B as C from my_table;

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

Comment By: Ludek Finstrle (luf)
Date: 2005-12-27 20:12

Message:
Could you send me compiled example as I have no VB?
How is your pdTable filled? What result return psql client?
Could you send me mylog output (enabled mylog under Global and DataSource button) too?

If you don't create this bug as anonymous you can append this files to the bug report ...

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

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000510&group_id=1000125

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: Table's Field Info
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1000514 ] Conexão ADO