spartacus
11th June 2007, 17:51
Is there way, using the properties of a input-field to restrict the input, let's say for a price, to the two digits, the format code (003) is designed for?
I know I can check via "check.input" or something like that. But isn't there anything in "the formeditor or the properties of the field" where I can easily restrict the input to two digits?
regards
PrinceUK
11th June 2007, 18:02
Have you had a look at ttadv3101s000? In Ivc4 this appears to offer minimum input length, and also for double and float fields the max length before and after decimal point.
spartacus
12th June 2007, 10:15
Hi Prince,
yes this is what I meant with "formeditor". In ERP there is a special TAB with display settings. There is als a switch "Input Length / Digits after Dec. point" which looks IMO very interresting. But however. I didn't see any influence to my field.
I always found that things on Baan IV easier. In ERP I'm somtimes a little confused, how field are displayed. Maybe this is also, that the field help, at least on our system, doesn't work anymore (that good), as it did in Baan IV.
en@frrom
12th June 2007, 12:25
you can set the input length yourself. If you want for instance 6 positions before the decimal point, out of which one mandatory, and 2 positions after decimal point, both mandatory, then you write as input length after dec. 2, before decimal 6, and then you will see that the display format will automatically be changed to ZZZZZ9VD99, although you can also change that...
Regards,
Eli Nager
spartacus
12th June 2007, 12:52
Hi Eli,
I tried that already. The result is not that, I would like to have.
Let's say I create a format like ZZZZ9VD9
Then the DISPLAY is according to that pattern, but during input I'm able to enter, for example "0.003". Afer input Baan shows "0.0" on the form, and in the table field I see "0.003".
I find this very confusing for the users. The only way to avoid this, seems for me at the moment, to write something in a "check.input" section or in a "dal.property.hook". This is a little bit anoying, 'cause IMO this is a thing, one should be able fix within the properties of a form field.
regards
en@frrom
12th June 2007, 13:18
Spartacus,
On my Baan 5.0B environment the behavious is different than what you describe. I can do the way I wrote in my earlier post, the only thing is, indeed Baan allows input of more than 2 decimals, however when inputing more than two, the system right away pops up with message "value not allowed", and does not enable saving the record. So the only inputable value is with maximum 2 decimals...
Regards,
Eli Nager
spartacus
12th June 2007, 13:55
Hi Eli,
your behaviour would be net that bad for me. I couldn't imagine why there should be such a big difference to 50.c. Maybe I make a mistake somewhere?
But it looks just to easy to make something wrong?
Regards