can't insert a record into the table

  • Thread starter Thread starter Dou
  • Start date Start date
D

Dou

Have a digital field and two date field in the table.
I want to insert a record into the table using the statement
INSERT INTO, If I only input other data, let the digital field's
textbox and date field's textbox empty,then I can't insert a record
into the table. I have set digital and date field's Required property
to No. How to solve this problem? thanks.
 
It's not clear if there are other fields in the table, or what the error is.


What if you open table using the UI and enter a new record leaving the
digital (Numeric) and date fields empty?
 
Yes, there are other fields in the table.
if I open table using the UI and enter a new record leaving the
digital (Numeric) and date fields empty, It's ok.
But It can't insert a record into the table using INSERT INTO statement when
input data in the form and leaving the digital (Numeric) and date fields
empty.
 
You might want to set the property "Allow Zero Length" for any text fields
in your table to allow zero length(Yes) strings.
 
Back
Top