SV: [Axapta-Knowledge-Village] not more than 100 %

[Søren Ager]

Den 7. maj 2008 12:31 skrev Axapta-Knowledge-Village@yahoogroups.com:

>           Has anyone come across this situation in standard AX,
> suppose you have field called percentage in your form and the total
> percentage should not be more than 100% if it exceeds so system
> should throw the error, percentage should be some of values in all
> the  rows.    

In ValidateWrite on the table do something like:

if ((select sum(percent) from mytable).percent>100)
        return checkFailed("Percent over 100");


Greetings
  Søren