Quick SQL Question

Hey,

I know thsi is a silly question but gonna ask it anyway :)

When you are using the 'insert' statement to insert records in to a database are all of the fields in the db table required for a successfull adding of a record.

Just that i have 16 fields in my db table and want to insert only 11 fields in to the new record and it is giving me an error, and i am sure my SQL is correct

So are all fields required ?

Thankyou

ChrisHey,

i have realised that the password field i am passing to the database causes the error, if i take this out, all values are added to the db. i have tried adding this field using a stored procedure but still causes the 'There is an error in your INSERT Statement" error.

Must i convert my password to some other data type before i add it?

I have out put my sql statement to a label and it sees the password fine but just doesnt add it, this is puzzeling me as it just a textbox and all the other text boxes add fine, i have checked the names of my control and database fields and all are correct.

Please help

chris|||Probelm Solved

Cheers anyway :)