EYoung
asked on
Loosing connection to MS SQL Server text field
Basics: VB6 sp5 on W/2000
In my app I am reading a MS SQL Server table that contains a text field. When I access the field for the first time, I can see the data, however, when I access the field the second time, I get a null. It is as if I loose access to the text field after I first touch it.
For example,
If rsTable1.Fields("TextField ") > "" Then
X = rsTable1.Fields("TextField ")
Else
X = ""
End If
In the above code, X always returns a null when there is something in rsTable1.Fields("TextField ").
Thanks for the help
In my app I am reading a MS SQL Server table that contains a text field. When I access the field for the first time, I can see the data, however, when I access the field the second time, I get a null. It is as if I loose access to the text field after I first touch it.
For example,
If rsTable1.Fields("TextField
X = rsTable1.Fields("TextField
Else
X = ""
End If
In the above code, X always returns a null when there is something in rsTable1.Fields("TextField
Thanks for the help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No need for a IF, use this:
X = rsTable1.Fields("TextField ") & ""
>>Not able to replicate the problem here at this office.
re-install mdac_typ.exe
X = rsTable1.Fields("TextField
>>Not able to replicate the problem here at this office.
re-install mdac_typ.exe
ASKER
Sorry for the delay in closing this out. I am not going to be able to test this for several weeks so I am just closing it out. Thanks for the help.
ASKER
I will not be able to test this until next Wednesday as the code is at a client's location and I won't be there until then.
Tried using the IsNull() at the client's offices yesterday but that did not make any difference.
Not able to replicate the problem here at this office. Not sure why. Will keep you posted.