In List

Jay Donelson Ide wrote:
Is there a finite number of items that can be input when using a ‘In list’
within a query?

Either 99 or 255, depending on your database.

Barbara Rosen

Database Development & Admin Services
Salomon Smith Barney
Phone: (212) 723-2756
e-mail: barbara.rosen@ssmb.com


Listserv Archives (BOB member since 2002-06-25)

In informix I can create a query like this

select…
from…
where

FIELDA =‘variable1’
OR
FIELDB =‘variable1’

To create this in BO there is no problem I select an object and say equal to prompt
But how can I create this???

select…
from…
where

‘variable1’ IN (FIELDA,FIELDB)

I wanna do this because In is mutch faster then OR


Listserv Archives (BOB member since 2002-06-25)

You could use designer to create a condition like: @variable(‘prompt’) IN (FIELDA,FIELDB)
Are you sure though that an IN is more efficient than an OR? As I understand it most SQL Optimisers convert an IN statement to multiple ORs anyway.

Kevin Charleston
SA Container Depots
Cape Town, South Africa

But how can I create this???
select…
from…
where
‘variable1’ IN (FIELDA,FIELDB)
<<


Listserv Archives (BOB member since 2002-06-25)