CODEWITHSUNDEEP
javasqlms-accessjdbcprepared-statement
Bobby
Bobby

Reputation: 18315

Prepared Statement Failing (With an Error Message!)

I am getting this error when trying to insert data into a data table

Error Saving data. [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect

I looked at the appropriate data table and there does not exist a field called COUNT either hidden or not hidden. Is this some SQL terminology that I should be familiar with?

An Extension of this Question

Upvotes: 0

Views: 370

Answers (2)

Bobby
Bobby

Reputation: 18315

It seems that passing null values into the prepared statement also causes this errror.

Upvotes: 0

ChssPly76
ChssPly76

Reputation: 100806

This is a generic error message which is usually caused by incorrect statement syntax (like missing quote somewhere). Double check your SQL and post it here along with parameters / table schema if you need further help.

Upvotes: 1

Related Questions