Page 1 of 1

Function in a Browse->Fields

Posted: Fri Apr 03, 2009 7:26 am
by ohaldi
Hello
How can I put a function in a Browse Fields ?
I only like to show a "*" if the Memo is not empty.

I tried this, but do not work:

DEFINE BROWSE Brow_Adr
....
FIELDS { "ADRESSE->NAME" , "ADRESSE->NAME_KZ" , "ADRESSE->ADR_NR" , "ADRESSE->PLZ_ORT" , {|| if(Empty(ADRESSE->MEMO)," ","*") } }

Many thanks in advance for any help.

Re: Function in a Browse->Fields

Posted: Fri Apr 03, 2009 8:29 am
by gfilatov
ohaldi wrote:Hello
How can I put a function in a Browse Fields ?
I only like to show a "*" if the Memo is not empty.

I tried this, but do not work:

DEFINE BROWSE Brow_Adr
....
FIELDS { "ADRESSE->NAME" , "ADRESSE->NAME_KZ" , "ADRESSE->ADR_NR" , "ADRESSE->PLZ_ORT" , {|| if(Empty(ADRESSE->MEMO)," ","*") } }

Many thanks in advance for any help.
Hello Otto,

Try this

FIELDS { 'ADRESSE->NAME' , 'ADRESSE->NAME_KZ' , 'ADRESSE->ADR_NR' , 'ADRESSE->PLZ_ORT' , 'ADRESSE->(if(Empty(MEMO)," ","*"))' }

I hope that helps. :idea:

Re: Function in a Browse->Fields

Posted: Fri Apr 03, 2009 10:18 am
by ohaldi
, 'ADRESSE->(if(Empty(MEMO)," ","*"))'
Work very well, Thanks