I am getting Problem to Update/Insert filed "PayrollInfoVacationHoursVacationPercentage" Table Employee

Query like:

UPDATE employee SET PayrollInfoVacationHoursVacationPercentage = 5.5 where ListID = ''

INSERT INTO Employee (FirstName,PayrollInfoVacationHoursVacationPercentage) VALUES ('Niranjan',5.5) 

Sorry, but you haven't said what the problem is? What's the error?

• Myquery:-    UPDATE employee SET PayrollInfoVacationHoursVacationPercentage = 5.5 where ListID = 'B0000-1226350695'

VB Demo 32 Error:-    [QODBC] Error : 3210 - The "Vacation percentage" filed has an invalid value "5.50000". QuickBooks error massage: This field accepts a maximum of two (2) decimal places.

• Myquery:-  INSERT INTO Employee(Salutation,FirstName,) VALUES('Mr.','Niku') ----Ok Working BUT

• INSERT INTO Employee(Salutation,FirstName,PayrollInfoVacationHoursVacationPercentage) VALUES('Mr.','Niku',4.5)  -----Same Error

VB Demo 32, is throwing error

Ok, what version of QuickBooks (country, year and edition) and revision of QODBC are you using? Please upload a screen dump of this query:

Select Salutation, FirstName, PayrollInfoVacationHoursVacationPercentage from Employee

See: How do I upload images to my forum post? 

Ok, what version of QuickBooks (country, year and edition) and revision of QODBC are you using? I can't tell from the copyright banner. Do Ctrl-1 while QuickBooks is running and look at the "About" tab in the QODBC Setup screen. Please also upload a screen dump of this query:

Select Salutation, FirstName, PayrollInfoVacationHoursVacationPercentage from Employee

Thanks for that, what happens when you use a integer instead? Does this work?

INSERT INTO Employee (FirstName,PayrollInfoVacationHoursVacationPercentage) VALUES ('Niranjan',4)

Your screen dump also only shows integer values for PayrollInfoVacationHoursVacationPercentage. Are there any entries with decimals like 4.5?