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