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

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=10005 10&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
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: 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=10005 10&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match