Another simple development question

djswim

So, I'm trying to run a line of code ONLY IF the Document Type field in the Sales Line table is NOT "Order" or "Quote". Here is what I have:

IF "Document Type" <> "Document Type"::Order AND "Document Type" <> "Document Type"::Quote THEN FunctionName();

I'm getting a type conversion error... Option AND Option.

This is 2009 SP1, although I'm pretty sure this is just a syntax thing I can't remember. As always, the help is very much appreciated.

anna_sicosbt

djswim wrote:

So, I'm trying to run a line of code ONLY IF the Document Type field in the Sales Line table is NOT "Order" or "Quote". Here is what I have:

IF "Document Type" <> "Document Type"::Order AND "Document Type" <> "Document Type"::Quote THEN FunctionName();

I'm getting a type conversion error... Option AND Option.

This is 2009 SP1, although I'm pretty sure this is just a syntax thing I can't remember. As always, the help is very much appreciated.

Try:

IF ("Document Type" <> "Document Type"::Order) AND ("Document Type" <> "Document Type"::Quote) THEN FunctionName();

Savatage

Just verify that these are your left over options....[Invoice,Credit Memo,Blanket Order,Return Order]

djswim

Perfect, thank you so much! As always, you guys rock!

David_Singleton

djswim wrote:

So, I'm trying to run a line of code ONLY IF the Document Type field in the Sales Line table is NOT "Order" or "Quote". Here is what I have:

IF "Document Type" <> "Document Type"::Order AND "Document Type" <> "Document Type"::Quote THEN FunctionName();

I'm getting a type conversion error... Option AND Option.

This is 2009 SP1, although I'm pretty sure this is just a syntax thing I can't remember. As always, the help is very much appreciated.

Why not

IF "Document Type" NOT IN ["Document Type"::Order."Document Type"::Quote] THEN 
  FunctionName();

Same result, but reads much easier.

djswim

I tried the "NOT IN" route but did something wrong because I got an error message saying that it needed to be a TRUE/FALSE or something like that. I can't remember.

Reinhard

NOT IN is not a valid syntax as far as I'm aware.

I always have to do this:

IF NOT ("Document Type" IN ["Document Type"::Order."Document Type"::Quote]) THEN 
  FunctionName();

Savatage

Try It

David_Singleton

Reinhard wrote:

NOT IN is not a valid syntax as far as I'm aware.

I always have to do this:

IF NOT ("Document Type" IN ["Document Type"::Order."Document Type"::Quote]) THEN 
  FunctionName();

I think you are probably right. I just wrote off the top of my head. Yours looks better. :thumbsup: