Solved

Can't have empty fields to update records?

Posted on 2001-08-03
3
170 Views
Last Modified: 2012-08-14
This question is a continuation to these two topics:

http://www.experts-exchange.com/jsp/qManageQuestion.jsp?ta=asp&qid=20162452

and

http://www.experts-exchange.com/jsp/qManageQuestion.jsp?qid=20161841

and

http://www.experts-exchange.com/jsp/qManageQuestion.jsp?qid=20162639

If I leave some fields blank it gives this error message:

Microsoft JET Database Engine error '80004005'

Field 'students.AptNumber' cannot be a zero-length string

The same applies to all fields.
How do I fix that?



0
Comment
Question by:amira123
3 Comments
 
LVL 28

Accepted Solution

by:
AzraSound earned 50 total points
ID: 6350353
look at the field definition in the database.  ensure that the AllowZeroLength property is set to 'Yes'.
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 6350393
Or validate the field prior to the update if you can't mod the dB, and insert a " ", or a "vbCr" in the field, anything that the field recognizes as notNull.
0
 
LVL 33

Expert Comment

by:hongjun
ID: 6350800
AzraSound is correct. Though your that field may indicate that null values is accepted, you do also need to set "AllowZeroLength" to yes/true.

hongjun
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question