What are the challenges you face when working across database platforms? Take the survey
Search
-
Cannot insert the value NULL into column
I am having a problem adding new columns to a table. The new table definition has new columns that are both NULL and NOT NULL. The SQL Compare Script creates a temp table to contain data from the target table. The insert it uses to populate this temp table fails because it does not provide a value for the new columns… -
Re: Cannot insert the value NULL into column
Unfortunately the column definition must remain NOT NULL without a default. The work around for me would be to specify a default value on the INSERT. I would use the system defaults like spoce, 0 or current_timestamp. I am looking for a tool that will automate this as much as possible. I have been using Embarcadero's…
2 results