--0-1927574124-1242034435=:99730
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi,
=A0I
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
=A0=A0=A0 Dim L_Result=A0 As rdoResultset
=A0=A0=A0 Dim SQL As String
=A0=A0=A0
=A0=A0=A0 SQL =3D "SELECT col1 FROM test"
=A0=A0=A0=A0=A0=A0=A0
=A0=A0=A0 Set L_Result =3D RDOConnect.OpenResultset(SQL, 3, rdConcurReadOnl=
y)
=A0=A0=A0 i =3D 0
=A0=A0=A0=A0
=A0=A0=A0 'Remark: The L_Result("col1") value missing in while loop second =
interation
=A0=A0=A0
=A0=A0=A0 While i <> 5
=A0=A0=A0=A0=A0=A0=A0 MsgBox "Loop " & i & " >>> " &
L_Result("col1")
=A0=A0=A0=A0=A0=A0=A0 i =3D i + 1
=A0=A0=A0 Wend
=A0=A0=A0=A0 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.
=0A=0A=0A
--0-1927574124-1242034435=:99730
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;"><div id=3D"yiv829255362"><br><table border=3D=
"0" cellpadding=3D"0" cellspacing=3D"0"><tbody><tr><td style=3D"font-family=
: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit=
; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font=
-stretch: inherit;" valign=3D"top">Hi,<br><br> 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 <br><br> =
Dim L_Result As rdoResultset<br> Dim S=
QL As String<br> <br> SQL =3D "SELECT c=
ol1 FROM test"<br> <br> &nbs=
p; Set L_Result =3D RDOConnect.OpenResultset(SQL, 3, rdConcurReadOnly=
)<br> i =3D 0<br> <br> &nbs=
p; 'Remark: The L_Result("col1") value missing in while loop second i=
nteration<br> <br> While i <> 5<b=
r> MsgBox "Loop " & i & "=
>>> " &
L_Result("col1")<br> i =3D i + 1=
<br> Wend<br> Exit Sub<br><br>Not=
e:-
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 .<br><br><br>Thanks,<br>Zahid K.<br></td></tr></tbody></table></div>=
</td></tr></table><br>=0A=0A=0A=0A
--0-1927574124-1242034435=:99730--
