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 .