|
Home > Archive > FoxPro Help and Support > June 2005 > left outer join using remote view designer
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
left outer join using remote view designer
|
|
|
| When I create a remote view using left outer join, it puts
{oj } codes in the select statement.
The view seems to run ok, but when I try to open it in the view designer I
get an error and I have to remove the {} codes in order to re-save the view.
Is there any way around this.
Thanks!
| |
| Fred Taylor 2005-06-03, 11:24 am |
| You'll have to not use the view designer, but create it in code using the
CREATE SQL VIEW command. The view designer doesn't handle all of the remote
syntax very well. What version of VFP?
There are other view designers that might handle the other syntax better,
like eView.
--
Fred
Microsoft Visual FoxPro MVP
"ghj" <ghj@ghj.com> wrote in message news:V2Pne.12822$zb.1970@trndny01...
> When I create a remote view using left outer join, it puts
>
> {oj } codes in the select statement.
>
> The view seems to run ok, but when I try to open it in the view designer I
> get an error and I have to remove the {} codes in order to re-save the
> view.
>
> Is there any way around this.
>
> Thanks!
>
>
>
>
| |
|
| VFP 9.0
"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:u6gpZ9EaFHA.796@TK2MSFTNGP09.phx.gbl...
> You'll have to not use the view designer, but create it in code using the
> CREATE SQL VIEW command. The view designer doesn't handle all of the
> remote syntax very well. What version of VFP?
>
> There are other view designers that might handle the other syntax better,
> like eView.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "ghj" <ghj@ghj.com> wrote in message news:V2Pne.12822$zb.1970@trndny01...
>
>
| |
| Fred Taylor 2005-06-04, 3:24 am |
| Well, that may be the best internal View Designer there is in VFP, but you
should still probably take a look at the others, like eView.
--
Fred
Microsoft Visual FoxPro MVP
"ghj" <ghj@ghj.com> wrote in message news:Tc6oe.36$wL2.1@trndny07...
> VFP 9.0
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:u6gpZ9EaFHA.796@TK2MSFTNGP09.phx.gbl...
>
>
|
|
|
|
|