A column in my SQL Server table is defined as numeric(4,2). In my PerfectForms database connection I created a SELECT action to retrieve all columns from the table, but I get an "Agent system error" when I test it. However, if I go back to the database and change the data type of the numeric column to anything else, the connection works. What's going on? I really need to save and retrieve numeric data to the DB.
PerfectForms Forums » General
"Agent system error" when retrieving numeric value from DB
(5 posts)-
Posted 1 year ago #
-
Do you have a null value in the column?
Posted 1 year ago # -
Yep, that was the problem. I changed the data type back to numeric then updated the value to 0.0 in the table, and I no longer get the error. That's a problem for me because null should be a valid value for the field in my form. Why are nulls a problem for PerfectForms in numeric columns?
Posted 1 year ago # -
I am not a developer so I cannot answer the question, but I am happy to hear that your connection is working properly!
Posted 1 year ago # -
OK, maybe you can ask your developers to look into it and fix it. :-) In the meantime I'll try changing my column to an int and multiplying and dividng by 100 so I an get a proper numeric value in the form.
Posted 1 year ago #
