Try this:

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

The ? tells VFP that selDate is a parameter.


>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