Thanks for your help, Sergey. I tried using both my own viewmaking utility and eviews - still does not work. Upgrading is unfortunately not an option, so it looks like I will have to use SPT.
-Justin
>Hi Jastin,
>
>I tested and it works in VFP8SP1. I get the same error as you do when I try to create this view in VFP7SP1. However, view created in VFP8SP1 works in VFP7SP1. If upgrade to VFP8 isn't an option, you may try third-party view editors as eView, e.t.c.
>
>>Hi Sergey,
>>
>>I get an error just when trying to create the parameterized version of the view - "No result set has been returned by the server." is the exact message. With the table name hard coded it works fine. My create view statement is identical to yours except the view and Connection names.
>>
>>I have VFP7 with SP1.
>>