|
| |
|
|
toddhenkel
Posts: 19
From: Tulsa, OK USA
Status: offline
 |
UPDATE with default values of NULL - 5/8/2001 21:04:00
I have built an update form that uses returned field values from an existing record using DRW. Not all of those fields have data - many are NULL.When I use the UPDATE in DRW, I get an error that the fields are not permitted to be a zero length string. The problem is that some of the fields must : ![]("http://128.242.235.130/ubb/mad.gif") : be NULL... I have not found a manner to incorporate a NULL value if the parameter is passed w/o data. And inserting a space, "NULL", or other characters royally messes things up...
|
|
|
|
Vince from Spain
Posts: 658
From: Madrid Spain
Status: offline
|
RE: UPDATE with default values of NULL - 5/9/2001 20:40:00
If you open your database table in design view, have you got the "Permit zero length" parameter set to false for these fields? If so, set it to true and everything should be ok.Vince
------------------
Internet Business Solutions S.L.(Spain)
| |
|
|
|
Guest
|
RE: UPDATE with default values of NULL - 6/6/2001 13:45:00
A few assumptions (wrong or right) before I ask my question;First, it is muy understanding Zero-Length Strings and NULL values are NOT the same thing. Second, I understand that Zero-Length Strings are not supported by SQL 7.0. Finally, for arguement's sake, let's assume that it is not desireable (i.e. maybe not practical becasue I have too many tables) to set the AllowZeroLength property in the table(s). The question becomes;
Is it possible to update a field with a NULL value? Thanks in advance
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
