help on list box

[manoranjan_d]

Hi,

I have given example below

table box

serialnum  value2  value3

1111         xxx     xxx

2222        xxx      xxx

3333         xxx      xxx

444           xxx      xxx

23424        xxx      xxx

6666          xxx      xxx

345345       xxx      xxx 

                 xxx      xxx

7777          xxx     xxx

3455          xxx     xxx

                 xxx    xxx

                 xxx     xxx

above one shows the table box and it contains serialnum, value2 and value3 fields.

note: serialnum filed have some blank value.

the blank value in the serialnum are  good rec and value which contains in serialnum are bad record.

example(1111, 2222,) are bad rec.

i created separate  list box for this good rec and bad rec.

below is the dynamic expression i used for good rec  list box

=if(len(serialnum)= 0 ,'Good Records')

when i click the good rec list box first time it got selected and its shows the good rec in table box, afterwards when i click the same good rec list, the selected item is released in table box. so this one working fine and good.

but when i used the expression in bad rec list box its not working fine

=if(len(serialnum)>0,'bad record').

when i click the bad rec list box first time it not selected and it get changed and shows the correct bad rec in table box, afterwards when i click the same bad rec list, the selected item is not released in table box. so i m having issue in this bad rec.

please help me on the bad rec expression.

[jonathandienst]

Hi

The null values are not selectable - you are trying to select them indirectly, and I think that may be part (or all) of your problem.

In the load script make the null values selectable, use

NULLASVALUE serialnum;

before loading serialnum. Or replace the null values of serialnum in the load:

LOAD....

     If(Len(serialnum) = 0, 'Missing, serialnum) As serialnum,

     ...

HTH

Jonathan

[PrashantSangle]

Hi,

Did you create two different list box??

just try with one list box

In script write

if(len(trim(serialnum))=0,'Good','Bad') as GB_Flag

Use GB_Flag in Front end and try it.

Regards

[manoranjan_d]

correct thanks to jonathan dienst max dreamer