Loosing connection to MS SQL Server text field
Posted on 2002-07-03
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.
If rsTable1.Fields("TextField") > "" Then
X = rsTable1.Fields("TextField")
X = ""
In the above code, X always returns a null when there is something in rsTable1.Fields("TextField").
Thanks for the help