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: 855813.99730.qm@web54502.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


Hi,

 I
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 & " >>> " &
L_Result("col1")
        i = i + 1
    Wend
     Exit Sub

Note:-
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 .

Thanks,
Zahid K.

Browse pgsql-odbc by date

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