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

“Agent system error” when retrieving numeric value from DB

Add a topic

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

Tagged: ,

This topic contains 4 replies, has 0 voices, and was last updated by  pmeidinger 8 years, 2 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.

Add a topic