The View Designer in VFP is very limited. Try ViewEdit from http://fox.wikis.com/wc.dll?Wiki~ViewEditor~VFP or file#9474 eView.

I'm not sure if you can find anything about VFP and MySql but there're few articles about VFP and MS Sql:

- http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgdesigning_client_server_applications.asp
- http://msdn.microsoft.com/vfoxpro/technical/articles/clientserver.asp
- http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgtskaccessingremotedata.asp

There's also book 'Client-Server Applications w/h Visual FoxPro and SQL Server' http://www.hentzenwerke.com/catalogavailability/csvfp.htm.

>Hi all, I have had some problems setting the query for a MySQL table in vfp.
>I have just send a parameter by name. like ?Cname, but I decided to click the case option in the view builder, after that an error when trying to edit the remote view says, like a vfp funcion that is not passed well to the database server.
>Question:
>1. If the sql for a remote view has to do with the backend server, why cannot be edited in order to send the query in the backend sintax .
>2. actually what sintax is permitted in the filter option
>3. where can find a good reference for ending to understand parametrized remote views
>4. a good source of client server development with vfp, actually i am using Promatrix enterprise
>
>Thanks
>
>Norman