Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is is me or a Bug?
Message
De
03/08/2004 15:19:51
 
 
À
02/08/2004 21:00:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Divers
Thread ID:
00929924
Message ID:
00930485
Vues:
20
>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).

Ah, now I see what you mean. It does show "Like" on the filter tab, but the SQL does indeed show "=". I would consider that a bug.

>
>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?
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform