NOT IN Operator

ck1ck1 Member Posts: 6
Hi Folks,

i tried to use a kind of NOT IN Operator that helps me to use some Statements conditional
var1 := 1;
var2 := 2; 
var3 := 3;

IF (Condition 1) and (Table1.field1 NOT IN [var1,var2,var3]) THEN BEGIN
   statement1;
   statement2;
END;
in this case i got an error from Compiler.

i also tried
IF (Condition 1) and NOT (Table1.field1 IN [var1,var2,var3]) THEN BEGIN
.. but i had not the effect i wanted.

thx for help

Comments

  • krikikriki Member, Moderator Posts: 9,110
    Try
    IF (Condition 1) and (NOT (Table1.field1 IN [var1,var2,var3])) THEN BEGIN
    
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.