Help with update error

[jwHerm]

I am receiving the following error:

 

"No value given for one or more required parameters."

 

When I executeNonQuery with the SQL:

 

UPDATE Employment_Info SET Company_Name = 'DerekINC', Employment_Title = 'New Workers', Full_Time = 564, Part_Time = 6546, Company_Type = 'Manufacturer', Wage_Survey = True, Manufacturing_Dir = True, Responded_WS = False, Responded_MD = True, Product_Service = '654654', Contact_Salutation = 'Mr.', Contact_First_Name = 'Jason', Contact_Last_Name = 'Helman', Contact_Title = 'kljlkj', Contact_Phone_Number = '0654654', Contact_Extension = '654654', Contact_Fax = '654654', Contact_Email = '654654' WHERE Company_Name = 'DerekINC' And Employment_Title = 'New Workers'

 

I have made sure that all the fields are spelled correctly and yes, Full_Time and Part_Time are number fields. All the rest are either Yes/No or text/memo. It seems to make no sense that this error would show up as I haven't set any of the fields to required. Also, I tried it with adding company_name and employment_title in the set part and without them in the set part, yet the error seems to still come up. Anyone have any idea on this?

[Robby]

Copy this update statement and run it in Query Analyzer or whichever provider you're using and see if it's functional.

[jwHerm]

An amazingly easy thing to do, yet never crossed my mind. Figured out the problem. Gotta love it when you switch between using Phone_Number and Phone as field names. Thanks a lot.