Type Mismatch Error – On Update

Comersus Version: 705
Database type: Access
Frequency: Permanent issue

I have created a new table and I am updating values in that table using the updateDatabase function. When I capture the sql statement and execute it in SQL Query panel in Backoffice it works. But executing the statement via the site generates a Sorry for the inconvenience. Update Error in registyModifyExec, error: Type mismatch – Err.Number:13 – SQL:UPDATE registries SET companyName='test' WHERE idregistries=3 where companyName is a text field. Please advise to what could be causing this issue. Select statements work fine.

One Comment

Add a Comment

Your email address will not be published. Required fields are marked *