Insert statement, NULL error

[schroednic]

Hi all;

I am trying to use an insert statement to update a table. I only want to update a few columns, but upon running the query it errors out stating that the other columns can't be NULL values.

Anyway around this, as I don't need to "add" info to those particular columns.

Thanks in advance.

 

[bborissov]

Either makes these columns NULLable either set default values for them.

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[bborissov]

I forgot to mention that if you make these columns NULLable the whole application could be ruined. So one more advice, provide values for them. This will cost you a few more click on keyboard, but after that you could sleep peacefully

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[simian336]

What Boris means is that when a table is created you can tell it not to allow some columns to be null.

So you either need to redefine your table and allow null values in those columns or simply put something in the columns.

Simi