Hi Lester,

In fact, what I want may be a bit too greedy, I am thinking of something
like this:

select * from TABLE1 :WHEREPARAM

where :WHEREPARAM might even be empty.

Best wishes,
jr

----- Original Message -----
From: <lester@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, August 01, 2001 8:21 PM
Subject: Re: [ib-support] Parameter in the Where clause


> > Is it possible to assign parameter in the WHERE clause section? I need
to dynamically determine the records return here.
>
> I hope so - all my code uses it!
>
> eg.
>
> WHERE KEY BETWEEN :FROM and (:FROM+1)
>
> to select a days worth of data.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>