>hi charles,
>i have tested a lot that view and finaly i have noticed something.
>
>when the remote view is created in the sql code form of the view designer the error FUNCTION NAME IS MISSING ). appears.
>but, when i create it on the main form it works.
>but, even if the view is well created and works there is another problem . i can't edit that view cause the same error FUNCTION NAME IS MISSING ). appears.
>
>i think vfp must have bug there. if you have some ideas about these i will appeciate th

All my VFP apps over ten years used remote view againsts SQL 2000, 2005 and 2008 backends and they all work. I don't think your problem is a VFP bug.

The view designer in VFP, however, has always had a lot of problems and is very unreliable. Once you fix something in the code for your view it is better to only edit it in code from that point on. The view designer is more likely to damage it than solve any problem.

But if you are not willing to post the code for us to look at I'm afraid there is nothing I can do for you.

Good luck.

(by the way there is a great view designer ViewEditor written by Steve Sawyer and Rich Schummer currently available at

http://whitelightcomputing.com/prodvieweditorpro.htm

which I highly recommend if you going to be working with remote views.

And for SQL server backend VFP apps, my choice for the absolutely best combination is Visual FoxExpress from F1Technologies using Dan Goodwins VFEGenview for the remote views. Amazingly productive combination )