valid views built in view designer can't be opened by view designer

When building remote views, I've noticed that I can build queries with the
View Designer on back ends that have non-Fox features, like spaces in the
field names. The View Designer works fine, the query works fine.

But if I try to reopen the view with the View Designer, I get "syntax error"
messages, so if I want to modify the view, I have to do it programmatically.

The View Designer in VFP9 is very good, and a big improvement over VFP8's
(which was a big improvement over VFP7's). But it really should be able to
open views that it itself created, don't you think?

Wolfgang
Sun Feb 13 07:14:36 CST 2005

Hi Paul!

I think you should try
SET ENGINEBEHAVIOR 80

--


------------------------------

Mit freundlichen Güßen aus der Zigarrenstadt

Wolfgang Schmale

------------------------------------------------

"Paul Pedersen" <no-reply@swen.com> schrieb im Newsbeitrag
news:ONGCMU5DFHA.560@TK2MSFTNGP15.phx.gbl...
> When building remote views, I've noticed that I can build queries with the
> View Designer on back ends that have non-Fox features, like spaces in the
> field names. The View Designer works fine, the query works fine.
>
> But if I try to reopen the view with the View Designer, I get "syntax
> error" messages, so if I want to modify the view, I have to do it
> programmatically.
>
> The View Designer in VFP9 is very good, and a big improvement over VFP8's
> (which was a big improvement over VFP7's). But it really should be able to
> open views that it itself created, don't you think?
>
>
>

Mark
Wed Feb 16 09:57:01 CST 2005

Hi Paul,
You might also want to use eView from Universalthread.com. ImO a great tool.
hth
Mark

"Paul Pedersen" wrote:

> When building remote views, I've noticed that I can build queries with the
> View Designer on back ends that have non-Fox features, like spaces in the
> field names. The View Designer works fine, the query works fine.
>
> But if I try to reopen the view with the View Designer, I get "syntax error"
> messages, so if I want to modify the view, I have to do it programmatically.
>
> The View Designer in VFP9 is very good, and a big improvement over VFP8's
> (which was a big improvement over VFP7's). But it really should be able to
> open views that it itself created, don't you think?
>
>
>
>

Paul
Wed Feb 16 17:04:11 CST 2005

I'll check it out. Thanks.

"Mark" <Mark@discussions.microsoft.com> wrote in message
news:1A5832C9-6929-4F59-BF8F-8F87FDA99893@microsoft.com...
> Hi Paul,
> You might also want to use eView from Universalthread.com. ImO a great
> tool.
> hth
> Mark
>
> "Paul Pedersen" wrote:
>
>> When building remote views, I've noticed that I can build queries with
>> the
>> View Designer on back ends that have non-Fox features, like spaces in the
>> field names. The View Designer works fine, the query works fine.
>>
>> But if I try to reopen the view with the View Designer, I get "syntax
>> error"
>> messages, so if I want to modify the view, I have to do it
>> programmatically.
>>
>> The View Designer in VFP9 is very good, and a big improvement over VFP8's
>> (which was a big improvement over VFP7's). But it really should be able
>> to
>> open views that it itself created, don't you think?
>>
>>
>>
>>