ZuperDuper
Programmer
I am trying to open up a dbf table with adodb.recordset
and put value to a tempString.
tempString.Text = polrs.Fields("MYFIELD").Value.ToString
the only problem is that if MYFIELD is empty, tempString=""
I guess that the field value is trimmed automatically, which is not good. What if I need to check for a substring with a field, I might run into outbounds error.
I know that I can check for an empty string, etc., but that could be a problem too, since I might need to check for spaces, in which case I would need to fill the temp string with spaces.
Is there a way to directly get the field and if it empty, get the equivalent in empty space string?
You should never underestimate the predictability of stupidity.
and put value to a tempString.
tempString.Text = polrs.Fields("MYFIELD").Value.ToString
the only problem is that if MYFIELD is empty, tempString=""
I guess that the field value is trimmed automatically, which is not good. What if I need to check for a substring with a field, I might run into outbounds error.
I know that I can check for an empty string, etc., but that could be a problem too, since I might need to check for spaces, in which case I would need to fill the temp string with spaces.
Is there a way to directly get the field and if it empty, get the equivalent in empty space string?
You should never underestimate the predictability of stupidity.