valid values 3

[lespaul]

I know I've seen something way more elegant than this:

if ADivision <> 1 and ADivision <> 5 and ADivision <> 12 and ADivision <> 15 and ADivision <> 17 then


can anyone please help me remember how to make a list of values and use the equivalent of IN?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[buho]

a) Ordinals:

a.1) Sets if your are using ordinals with ordinality between 0..255.

if ADivision not (in [1, 5, 12, 15, 17]) then ...

a.2) "Case" statement otherwise.

case ADivision of
  1000, 5000, 12000, 15000, 17000 : ....;
  case else                       : ....
  end;

b) "If" statement for strings

buho (A).

 

[lespaul]

I guess I just wasn't getting the IN syntax correct! I knew it could be done though!

have a star!

les

 

[towerbase]

buho,

shouldn't
a.1)
be

if not ( ADivision in [ 1, 5, 12, 15, 17 ] ) then ...

and
a.2)
be

case ADivision of
  1000, 5000, 12000, 15000, 17000 : ....;
  else                       ....
  end;

Andrew
Hampshire, UK

 

[lespaul]

I'll try that tomorrow Andrew, I couldn't get buho's to work correctly, so you're probably right!

les

 

[buho]

Indeed, Andrew!

What a mess I did. Passing the star to you.

buho (A).

 

[lespaul]

Yeah! Thanks for all the help, a.1 worked just fine!

Les