iif()

[asm338s]

I am using IIF() in a report by saying:
IIF(exp1, '', resultExp)
Is there anyway I can check for two expressions. For example: IIF(exp1 AND exp2, '', resultExp)

 

[jimstarr]

Your example would work.

Jim

 

[DSummZZZ]

IIF()'s can also be nested:

IIF(exp1, IIF(exp2, '', resultExp2), resultExp1)

And so on.

Dave S.

 

[SGLong]

You might even want to create a function in your main program or procedure call and reference that in your detail band (i.e. myrepfunction()). I've done that when the nested iffs get really complex.

 

[273485]

iif(sts='A','Active',iif(sts='M','Martched ','Cancelled'))

Hope this help u.

 

[Guest_imported]

I am connecting to a paradox database and using SQLEXEC statements to retrieve data. I need to join to tables when I retrieve the information. ie(SQLEXEC('Select borrower.loannumber from borrower join loanacc on borrower.loannumber = loanacc.loannumber', 'la'). When I try to use a join I do not get any data. If I use two SQLEXEC statements (IE. select * from borrower - Select * from loanacc) and put the data into two cursor then I can join the cursors. The problem is I have to retrieve every record in borrower and loanacc. I only want the mathcing records. Does anybody know why a join will not work against a paradox database?

 

[DSummZZZ]

You may want to start a new thread for this one.

Dave S.

 

[jhall156]

You can also build text end to end i.e.
lc_text = iif(cond,truepart,falsepart) + iif(cond,truepart,falsepart) etc.
This is useful when you are using iif in a query. Too many nesting levels will, aside from being a nightmare to maintain, generate a 'too complex' error. JHall