Problem related to null value in sql statement

[kamina23]

Hi friends,
I am getting problem in following SQL statement.

 sql = "insert into table2values("& id &"," &_
	"" & active & "," &_
	"null," &_
	"'" & 1stName & "'," &_
	"'" & 2ndName & "'," &_
	"'" & 3rdname & "'," &_
              etc...

In above query null value shows in red color, it means there is error related to "null" value. Before this error message I have added 2 columns. Can anyone tell me how to fix this problem.
Thank you.

[Praetor]

I think there is problem in "null" value, it means error is not connected to that "null" value. I think it might be because you haven't added values for the 2 fields which you are recently added in your insert statement. In this case you have to deleted the columns to fix this problem. After deleting that column you will not get any error.

[Katty]

You are getting such type of problem because you haven't declared Field name in your SQL statement. In this case you have to declared Field name in your SQL statement to fix this problem. I have written following SQL query using Field name, just try to use this query in your code to fix this problem.

sql = "insert into table1values (Field1, Field2, Field3, ...) Values ("& ids &"," &_
	"" & active & "," &_
	"null," &_
	"'" & 1stName & "'," &_
	"'" & 2ndName & "'," &_
	"'" & 3rdname & "'," &_
              etc...

[kelfro]

When you create new columns you have to define default value other than NULL. Whenever you create the extra columns, you have to tell the database that nulls were acceptable for new fields. In this case you have to tell the database that nulls were acceptable for new fields. Whenever you insert a new record into that table, 2 columns automatically created. You have to remove that 2 fields to fix this problem.

[Zecho]

You have to Update ALTER TABLE to fix this problem. As per my information it seems that you have use wrong SQL statement for updating table1 and that's why you are getting such type of problem. You have to use following SQL statement in your code to fix this problem.

sql= "alter table tableA ADD Updated datetime NULL"

After this you will not get any problem.