>>I had remote view created from ORACLE, and ORACLE ODBC driver by default create datetime
>>datatype for date field, but I had done the mapping to get just date in my view, it work
>>fine, but if I do REQUERY, I will get error message as
>>
>> Error Message: 'View defination has changed'
>>
>>The cause of error is clear, because I had maped datetime field to date. But I want to
>>do the REQUERY(), without closing Dataenvirnomet. Does anybody have any idea for
>>requerying this view.
>
>Have U tried setting the view back to its defaults before doing a REQUERY() then setting it back to your mapping after? I know is a kludgy workaround... but its the first thing I'd think of doing when working with kludgy VFP. ;)


How about creating a temp field on the fly in the SQL statement?

Tom