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: 855813.99730.qm@web54502.mail.re2.yahoo.com (view raw or flat)
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.



      

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-2014 The PostgreSQL Global Development Group