2 nested IIFs: I don't get it!

waeberdwaeberd
edited 9:18PM in FastReport 3.0
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

Comments

  • AlexTZAlexTZ
    edited 9:18PM
    Improper use of inner '[]' symbols. Correct way is:
    [IIF(<frxMySource."TEXT1"> = '',
 <frxMySource."TEXT2">,
 IIF(<frxMySource."TEXT3"> = '',
   <frxMySource."TEXT1">,
   <frxMySource."TEXT3"> + ' / ' + <frxMySource."TEXT1">
 )
)]
  • waeberdwaeberd
    edited September 2004
    exactly! Thanks a lot!

Leave a Comment


Home • FastReport 3.0Comment As ...

© Vanilla Keystone Theme 2025