How do I say NOT IN in an IF statement

[jmueller]

This has to be an easy one!

What's wrong with the following IF statement:

-------------------------------------------------------
If {BBJOBCST.SHIFT} NOT IN [AllShifts]
Then (TotalShiftsWithRuns = TotalShiftsWithRuns + 1;
AllShifts = AllShifts + "," + {BBJOBCST.SHIFT})
-------------------------------------------------------
The variables are all initialized.

I get an error saying "The Keyword THEN is missing" and puts the cursor right before the NOT statement.

Your help is very much appreciated.

Jack.

 

[IdoMillet]

Jack,

Change to:
-------------------------------------------------------
If NOT({BBJOBCST.SHIFT} IN [AllShifts])
Then (TotalShiftsWithRuns = TotalShiftsWithRuns + 1;
AllShifts = AllShifts + "," + {BBJOBCST.SHIFT})
-------------------------------------------------------
Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[jmueller]

That did it! Thanks Ido.