I am able to easily replicate. Are you actually showing SQL or running the query and not just looking at the filter tab (it displays Like on the Filter tab, but if you right click and Show SQL it is using =, not Like).

I am even able to replicate with a brand new database:

CREATE DATABASE test
CREATE TABLE test1 ( abc c(20), efg c(20))
CREATE VIEW vtest1 as select * from test1 where abc like 'c%'

MODIFY VIEW vtest1 && close this view and modify again

MODIFY VIEW vtest1 && right click and show sql, no longer using Like

I don't know if it matters or if there are actually different versions of the beta, but I am running Visual FoxPro 09.00.0000.1720 (on Windows Server 2003).

Also, I am running all of the above commands separately from the command window (not a prg).


>>>Hi Robert,
>>>
>>>I am not able to reproduce behavior that you've described. Could you post exact repro steps?
>>>
>>>Thanks,
>>>Aleksey.
>>
>>Excuse me for jumping in. I know this is hard to replicate, so I wanted to go ahead and show one way I am able to replicate:
>>
>>OPEN DATABASE HOME()+"samples\Northwind\northwind.dbc"
>>CREATE SQL VIEW "TEST" ;
>> AS SELECT ProductID, ProductName ;
>> FROM Products WHERE ProductName like 'C%'
>>
>>* once view is open for mods, just close it
>>* (or run query, view sql, etc. without problems)
>>* note you can open some other view too (not just the new view)
>>MODIFY VIEW TEST
>>
>>* now modify the new view again, view sql, etc.
>>* although screen shows Like, sql expression is using =
>>MODIFY VIEW TEST
>
>Sorry, I can't repro any problem with the above code. I still get the "like" in the view no matter how many times I edit it. You might have a corrupted .DBC?