A
Angela
Hi
I am building a very simple data entry system with many forms and
input textboxes.
When I leave any part of the form empty (it allows nulls) it seems to
touch the field in the DB and the field is no longer NULL.
I have written a script to test for empty textboxes and insert DB.NULL
which is fine but when I want to load the data back into the form
(i.e. NULL value into a textbox) it gives me an error.
Is it a bit overkill to replace 'no data' with DB.Nulls before
updating the DB and then do another test to test for DB.Nulls and
replace with empty string when retrieving the data from DB??
I am building a very simple data entry system with many forms and
input textboxes.
When I leave any part of the form empty (it allows nulls) it seems to
touch the field in the DB and the field is no longer NULL.
I have written a script to test for empty textboxes and insert DB.NULL
which is fine but when I want to load the data back into the form
(i.e. NULL value into a textbox) it gives me an error.
Is it a bit overkill to replace 'no data' with DB.Nulls before
updating the DB and then do another test to test for DB.Nulls and
replace with empty string when retrieving the data from DB??