| Author |
 Topic  |
|
|
leblanc9425
New Member
USA
92 Posts |
 Posted - 12 August 2003 : 13:04:27
|
This should be easy, but how to I update a database field (using Access 2000) to show a completely empty field?
My problem is, that after I write some data into a field and then try to remove the data via using "update" it seems to leave an "invisible" character (like a space). So, when I try to locate all records where the field "isNull", the updated fields are NOT null because of this invisible space character.
When I open the database table, the field looks empty (hence why I call it invisible) but there is actually a space character in it. The only way to fix it, is to enter text, then highlight the cell and delete.
This is similiar to what I have done to update the field "masspaydate"
from a field WITH data (somevalue) to one that should be empty:
dim empty
empty=""
mySQL="UPDATE masspay set masspaydate='"&empty&"' where masspaydate='"&somevalue&"'"
set rs=openRSexecute(mySQL) |
www.Slug-Lines.com
Snitz Version 3.4.07 |
|
|
Anacrusis
Junior Member
USA
219 Posts |
|
|
leblanc9425
New Member
USA
92 Posts |
Posted - 12 August 2003 : 15:49:08
|
| Thanks Anacrusis! It kills me that I spent a few hours trying to figure this out.... |
www.Slug-Lines.com
Snitz Version 3.4.07 |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 12 August 2003 : 17:29:24
|
| Note, there is a difference between Null and Empty. You were setting the fields to Empty, but were searching for Null, that's why you didn't find anything. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Anacrusis
Junior Member
USA
219 Posts |
|
| |
Topic |
|
Topic Locked
