table control - validate column

[Former Member]

Dear VC Experts,

we are using VC with a RFC Data Service. On the output port we create a table control with following columns for example:

- Amount /MENGE (mandatory field)

- Checkbox type /BOOL1 (mandatory field) - true,false

- Expression Box / STATUS2 (validate amount and Checkbox) --> true, false

For the expression box we use the formula:

BOOL(@BOOL1==true AND @MENGE==0 OR @BOOL1==false AND @MENGE<>0)==true

This seems to work. Result: true, false

Further we have a button, which has to be disabled if the Expression Box has the status "false".

I dont know how to check all the values in the expression box. The button only gets disabled, if i select a specific row with the status 'false'. I would like to check all the valus in my table control, not only the selected one.

On the properties tab for my button i use the formula:

CONTAINS(#ID[ACC153]@STATUS2,'false')==true

Maybe any suggestions to check all the values in my table column? How can i check all the values in my column 'STATUS2' which contains true or false?

Moderator message - Please do not offer points or rewards

Edited by: Rob Burbank on Aug 3, 2010 11:32 AM

[Former Member]

For example you can have a look at the screenshot

[http://a.imageshack.us/img806/7914/sdnforum2.jpg]

Edited by: Akan Korul on Aug 5, 2010 1:52 PM

[Former Member]

Hello,

I think you need to attach the output of your table to the input of the form that contains your button, so that this form "is aware" that you have changed the selected line.

Then you assign an action to the mapping and to the column so that when you click on a line of the table it "calls" the form.

You can give it a try, but I'm not sure of this.

Fabien.