[ 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 | 20060110171158.1E42D1033DFD@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: Open Resolution: Accepted Priority: 3 Submitted By: Nobody (None) Assigned to: Ludek Finstrle (luf) 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-10 18:11 Message: For UNION problem I found the fix. Patch attached. If you need Windows DLLs, please let me know. ---------------------------------------------------------------------- Comment By: Ludek Finstrle (luf) Date: 2006-01-10 15:33 Message: Similar problem is: CREATE TABLE A( COL VARCHAR(3) ); CREATE TABLE B( COL VARCHAR(6) ); INSERT INTO A VALUES ('T1'); INSERT INTO A VALUES ('T2'); INSERT INTO A VALUES ('T3'); INSERT INTO B VALUES ('T4'); INSERT INTO B VALUES ('T5'); INSERT INTO B VALUES ('T6'); When it is called SELECT COL FROM A UNION SELECT COL FROM B throught ADO the result is: COL --------- T1 T1 T1 T1 T1 T1 ---------------------------------------------------------------------- Comment By: Ludek Finstrle (luf) Date: 2006-01-03 13:43 Message: I misunderstood who is author of this report ... Bug=report is reopened. You're right about my e-mail. I think it isn't needed to open bug under another ID. ---------------------------------------------------------------------- Comment By: Milton Siqueira (miltonsiqueira) Date: 2006-01-02 21:23 Message: Hi, Ludek Finstrle!!! Shortly i will send a compiled example, ok?! your email is luf@pzkagis.cz? =========================== pdTable --------------------------- A(VARCHAR) B(VARCHAR) --------------------------- 'Field1' 'Field2' =========================== I already done account(miltonsiqueira), Shall I open the same bug again (now with my login)? ---------------------------------------------------------------------- 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: