Thread: psqlodbc driver issue

psqlodbc driver issue

From

Zahid Khan

Date:

11 May 2009, 09:40:45

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.