Skip site navigation (1) Skip section navigation (2)

psqlodbc driver issue

From: Zahid Khan <khanzahid235(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: psqlodbc driver issue
Date: 2009-05-11 09:33:55
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc

am using psqlodbc driver with VB.and when i fetch data from table (
text column ) i get the result but when i try to get same column 2nd
time then i get the empty value.Following is the code sample 

    Dim L_Result  As rdoResultset
    Dim SQL As String
    SQL = "SELECT col1 FROM test"
    Set L_Result = RDOConnect.OpenResultset(SQL, 3, rdConcurReadOnly)
    i = 0
    'Remark: The L_Result("col1") value missing in while loop second interation
    While i <> 5
        MsgBox "Loop " & i & " >>> " &
        i = i + 1
     Exit Sub

at first iterantion of while loop i get the valid value but at the
second iteration of loop i get the empty value.It is only for text
column .

Zahid K.


pgsql-odbc by date

Next:From: prashanth k pDate: 2009-05-11 10:02:50
Subject: client encoding mismatch
Previous:From: postgresqlodbc.domain.thewild_codataDate: 2009-05-06 09:58:40
Subject: Re: INSERT on MSAccess linked ODBC table : out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group