fields are part of the VIEW's SELECT STATEMENT.
-----Original Message-----
From: Won Lee [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 6:55 PM
To: CF-Community
Subject: sql + view
Does anyone have the syntax to create a view where you can pass in
variables?
I used to call the view
select * from vw_need_outside where yesterday = myVar and today = myVar
This was the SQL I worked off.
--higher
select e.tickerRealTick
from prices p , prices pp , equities e
where p.equityID = e.equityID and pp.equityID = e.equityID and
p.priceDate = @today and pp.priceDate = @yesterday and
pp.equityID = p.equityID and p.high > pp.high and p.low < pp.low
and p.[close] > pp.high
order by e.tickerRealTick
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
