Insert Into

[tlmm]

I created an ASP page and I am trying to insert a record into an Microsoft Access (2003) database. If I don't put a date or a number in a textbox and try to insert it into the database, where these fields are represented by a number or date datatype in the database, the insert statement errors out. If I do put a date or a number in these textboxes the insert statement works fine.

Is there way to represent a null date in an Access database?

Is there way to represent a null number in an Access database?

Thanks.

 

[FesterSXS]

what error are you getting?

If it is along the lines of "myField does not accept null values" then you need to change that setting within the database table itself in the Design view.


Tony

http://www.SpiraxSarco.com

 

[DreXor]

Is there way to represent a null date in an Access database?

Is there way to represent a null number in an Access database?


for both :

insert into table(numberfield, textfield) values(null,null)

if allow zero length or required or disallow null is set on the fields you will need to change the data constraints on the db in order to fascilitate what you're trying to do.