Home » Category » Database & Application Miscellaneous

Database & Application Miscellaneous: Zero Length Date Fields in Databases

104| Thu, 29 Nov 2007 19:36:00 GMT| mikegoodman| Comments (1)
Can any one tell me how to save 'Nothing' to a Date field in a recordset.
Senario;
A date has been saved to a Date Field, thus changing the field from Null. The date is then not needed and deleted from the corresponding textbox object bound to the field. If I leave the textbox empty I get Data Conversion Error.
Surely there must be a way? . . .

[This message has been edited by Mike Goodman (edited 09-28-1999).]

Keywords & Tags: zero, length, date, fields, databases, database, application

URL: http://database.itags.org/database-application/158196/
 
«« Prev - Next »» 1 helpful answers below.
You told that you try to update "nothing" into the field.
if your program corverts an empty textbox into value "" that cant be updated into the datetime field.

You can insert or update value Null into a datetime field.

recards Jamppa

jamppa | Thu, 06 Dec 2007 01:15:00 GMT |

Database & Application Miscellaneous Hot Answers

Database & Application Miscellaneous New questions

Database & Application Miscellaneous Related Categories