Issue
I am developing an application using postgresql and have a table for company data. When I update a record with a national code that begins with 0, I get a format error because it's saved as varchar. When creating a new record, the national code saves without the initial 0. How can I fix this? With the help of a community member, I turned off prepared statements and added quotes to ensure correct formatting of the DB values being passed in the query, which resolved the issue.
Resolution
The solution is to disable the prepared statements in the query's settings and making sure that all database values being passed in the queries are in the correct format. For a varchar, the value should be something like '{{nationalCodeInput.text}}' with quotes added.