If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Insert null value in column-type is date/time & format is ShortDate,in Access 2002
Hi,
I am trying to insert Null value in column(ShipDate) in my table.That column(ShipDate)'s type id date/time and format is short date. I am using "" to insert Null in that column(ShipDate) but it shows warning that customer can't append all the records in the append query. Customer set 1 field(s) to Null due to a type conersion failure,and it didn't add 0 record(s) to the table due to key violation, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations. Do you want to run the action query anyway? But still if I click on Yes than it will simply execute the query and insert null value in table. And if I click on No than it cancel the execution of query. its caused just because i set type as date/time and put format as short date in that column(ShipDate) in my table. How can I remove this warning? |
#2
|
|||
|
|||
Insert null value in column-type is date/time & format is ShortDat
I am using "" to insert Null in that column(ShipDate)
What you are trying to insert is not a null but an empty string. Use NULL instead. If you are running an update query then in the design view of the query grid row for Update type NULL as the data. -- KARL DEWEY Build a little - Test a little " wrote: Hi, I am trying to insert Null value in column(ShipDate) in my table.That column(ShipDate)'s type id date/time and format is short date. I am using "" to insert Null in that column(ShipDate) but it shows warning that customer can't append all the records in the append query. Customer set 1 field(s) to Null due to a type conersion failure,and it didn't add 0 record(s) to the table due to key violation, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations. Do you want to run the action query anyway? But still if I click on Yes than it will simply execute the query and insert null value in table. And if I click on No than it cancel the execution of query. its caused just because i set type as date/time and put format as short date in that column(ShipDate) in my table. How can I remove this warning? |
#3
|
|||
|
|||
Insert null value in column-type is date/time & format is ShortDat
Null and "" are not the same thing. Use Null
A date/time table field will accept Null, but not "" which is a string or text value -- Dave Hargis, Microsoft Access MVP " wrote: Hi, I am trying to insert Null value in column(ShipDate) in my table.That column(ShipDate)'s type id date/time and format is short date. I am using "" to insert Null in that column(ShipDate) but it shows warning that customer can't append all the records in the append query. Customer set 1 field(s) to Null due to a type conersion failure,and it didn't add 0 record(s) to the table due to key violation, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations. Do you want to run the action query anyway? But still if I click on Yes than it will simply execute the query and insert null value in table. And if I click on No than it cancel the execution of query. its caused just because i set type as date/time and put format as short date in that column(ShipDate) in my table. How can I remove this warning? |
Thread Tools | |
Display Modes | |
|
|