Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Insert NULL into Pocket Access

Comment:

I am baffled that I cannot insert a null into any type of column in my Pocket Access table on my iPAQ. Any time my insert statement contains the word null I get the error "The command contained one or more errors." Even when I just put '' into the field, it puts in the value of the column immediately to the left of it. The columns do not require values and have no defaults set. Is that happening to anyone else? I absolutely cannot get a null to be inserted.

Reply:

have you the allow NULL set to true, you don't have to insert NULL, just name fields to insert ie insert tblExample (colunm_1,Column_3) VALUES('One','Three') --(this should put NULL into coulumn_2)

0

PLZ Help ME!!!!

cold fusion vs. Oracle

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I'm moving a text file from a network drive and inserting it into an access database. Is there anyway to say go and grab the file with the most recent modified date? They are adding a file each busi...

Summary: I am having trouble inserting data into my access 2000 database. I am using dreamweaver to create the asp page and am running IIS 5.1 to host. The database is in the same folder as the .asp page. All...

Summary: What's a good way to insert commas into numeric output in c++? For instance long l = 12300 would be output as 12,300. ...