I created a parameterized view Using create SQL view command.

create SQL view result_oneday ;
as select * from Clinic!bridge where bridge.date=selDate

It works fine If I use it as it originally was.
I tried like the followings,
selDate=date()
use bridge
brow

But after I opened the view designer to change update Criteria,
where clause becomes like the followings,
bridge.date="selDate" and return type mismatch error.
I tried many time without success.
I don't know what causes this failure.
Would you please help me out there?


Yong seung Kim