Thank you very much josh!
Yong seung Kim
>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
If you have a chance to visit Korea, Be my Guest.
rexall