2 nested IIFs: I don't get it!

waeberd

Hi,

I don't get it! I have a memo field with the following "OnBeforePrint" handler:

 if <frxMySource."TEXT1"> = '' then
    Memo19.Text := <frxMySource."TEXT2">
  else if <frxMySource."TEXT3"> = '' then
    Memo19.Text := <frxMySource."TEXT1">
  else
    Memo19.Text := <frxMySource."TEXT3"> + ' / ' + <frxMySource."TEXT1">;

Works fine, is elegant!

But I'd like to pack this into two nested IIF expressions.
I always get an "invalid variant operation" error...

my try was:

[IIF(<frxMySource."TEXT1"> = '',
  <frxMySource."TEXT2">,
  [IIF(<frxMySource."TEXT3"> = '',
    <frxMySource."TEXT1">,
    <frxMySource."TEXT3"> + ' / ' + <frxMySource."TEXT1">
  )]
)]

What's wrong here?

Thanks!

Daniel

AlexTZ

Improper use of inner '[]' symbols. Correct way is:

[IIF(<frxMySource."TEXT1"> = '',
 <frxMySource."TEXT2">,
 IIF(<frxMySource."TEXT3"> = '',
   <frxMySource."TEXT1">,
   <frxMySource."TEXT3"> + ' / ' + <frxMySource."TEXT1">
 )
)]

waeberd

exactly! Thanks a lot!