>Hi !
>
>In VFP5.0a in the View Designer->Filter->Example, how can I get rid of the quotation marks that VFP wraps around any example expression you provide when you have a look at the code with the SQL button.
>
>All I want to do is to have Example to contain UPPER(NameMyVar)
>
>but VFP insist in having it "UPPER(NameMyVar)" and when I return to the box Example, sure enough it has the quotation marks !
>
>
>TIA
>
>Pierre Richard
I don't know how you could correct it there because I don't use the designer. Just copy the SQL, don't save the design (?), go to command window and paste it like :
create sql view "myView" as select ....
You could play with it more flexibly there.
OTOH since NameMyVar reminds a variable maybe you could just have your filter as :
upper(?NameMyVar)
Cetin