Home> General > “Agent system error” when retrieving numeric value from DB

“Agent system error” when retrieving numeric value from DB

Tagged: action, DatabaseConnection

This topic contains 4 replies, has 0 voices, and was last updated by pmeidinger 8 years, 4 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)

Author
Posts
March 9, 2011 at 8:22 pm #702

pmeidinger
Participant
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.
March 10, 2011 at 5:45 pm #5633

Dennis @ PerfectForms
Blocked
Do you have a null value in the column?
March 10, 2011 at 5:56 pm #5634

pmeidinger
Participant
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?
March 10, 2011 at 6:00 pm #5635

Dennis @ PerfectForms
Blocked
I am not a developer so I cannot answer the question, but I am happy to hear that your connection is working properly!
March 10, 2011 at 6:04 pm #5636

pmeidinger
Participant
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.
Author
Posts

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.