Newbie Questions

Re: Using Negative Values in Drop List

Uncle Paulie — Fri, 10 Feb 2012 14:07:14 GMT

Thanks Jimmy. I hadn't taken that into consideration. I appreciate the insight.

Re: Using Negative Values in Drop List

Jimmy — Thu, 09 Feb 2012 23:03:11 GMT

It appears that tinyints can only take on values between 0 and 255, no negatives:

http://msdn.microsoft.com/en-us/library/ms187745.aspx

Any chance of changing the datatype of this field in the database?

Re: Using Negative Values in Drop List

Uncle Paulie — Thu, 09 Feb 2012 17:42:12 GMT

The field is bound to a SQL db table. The data type is tinyint. There is no customer validation associated with this field.

Thanks!

Re: Using Negative Values in Drop List

Jimmy — Thu, 09 Feb 2012 16:58:53 GMT

Hello,

Could you tell us the datatype of the field the dropdown is bound to? Is there any custom validation on it?

Using Negative Values in Drop List

Uncle Paulie — Thu, 09 Feb 2012 15:07:20 GMT

I have a form used for scoring associate performance. There are 16 questions, each with a corresponding drop list containing the values (or score) that can be assigned to the associate's performance as it relates to each question.. Currently all of the values placed in each drop list are positive values. I have made a modification to our scoring process and now wish to use negative values in my drop lists as well. However, I am getting an error when I attempt to add negative values to my drop down's values list indicating the specified value is not valid. I have also tried creating a rule that forces the positive values in the drop list to negative values. This works and my calculation of the total of all the list boxes is correct. However, there is a dotted red line around the drop down where the negative value was selected.

Can anyone point me in the right direction to make this work?

I am using InfoPath 2007.

Thanks!