Help with filter syntax

[ianburgess]

I have a drop list on a form which has the following filter which works fine:

'A_USE:Active = ' & True & ' AND A_USE:Administrator <> ' & 2

I  need to add to the filter so that to pass, A_USE:Administrator must not be equal to 2 (as before) and either A_USE:Active is True OR the form is being "changed", but I cannot find how to test for the form being changed or syntax as to how to insert the test into the filter expression?

Anyone's help would be greatly appreciated.

Ian

[Niels Larsen]

Like this

'A_USE:Active = ''1'' AND A_USE:Administrator <> ''2'''

or like this

p_web.GSV('A_USE:Active') & '= ''2'' AND ' & p_web.GSV('A_USE:Administrator') & ' <> ''2'''

/Niels

[Bruce]

>> I cannot find how to test for the form being changed or syntax as to how to insert the test into the filter expression?

Choose(loc:act = Net:ChangeRecord,'1','A_USE:Active = 1') & ' AND A_USE:Administrator <> 2'

cheers
Bruce

[ianburgess]

Thanks Bruce, I will give that a try. Are you saying that you cannot use OR in the expression but must use CHOOSE instead?

What if you wanted more than two ORs, eg. expression1 OR expression2 OR expression3 ?

Thanks

Ian

[Bruce]

no, not at all.

In your case you didn't really have an OR clause, because the "form is in change mode" is really not related to the data. So in your case it wasn't necessary to make that part of the filter, but rather decide if it should be in the filter or not.

Because your one clause was going to be either true, or false, if it was embedded in the filter your filter would look something like;

'(A_USE:Active = ''1'' or true) AND A_USE:Administrator <> ''2'''
which is obviously the same as
'1 AND A_USE:Administrator <> ''2'''
which is the same as
'A_USE:Administrator <> ''2'''

or, if the form was not in change mode then
'(A_USE:Active = ''1'' or false) AND A_USE:Administrator <> ''2'''
which is the same as
'A_USE:Active = ''1'' AND A_USE:Administrator <> ''2'''

Cheers
Bruce