Strange View Problem

I have a view that works just fine and has 4 tables in it joined together.
If I open it in the view designer, one table is missing(you can see the
whole). If I do nothing to the view and just save it, it errors on the
field in the missing table. If I add the table in, it errors on another
field that was/is in the field list. After the error, I keep getting the
error when I try to modify the view. I can't get it open. This is a very
compicated view that I do not wish to recreate. Any ideas?

As a work around, can I add a field to the view programmatically with
dbsetprop() . The field is in a table that already exists in the view.

Thanks for your help.

Cory Bonallo
Developer

Dan
Wed Jan 12 15:34:49 CST 2005

What version of VFP?

Recent versions have included MAJOR enhancements/changes in the view
designer, so anyone approaching this needs to know what environment you're
working in.

Dan

Cory Bonallo wrote:
> I have a view that works just fine and has 4 tables in it joined
> together. If I open it in the view designer, one table is missing(you
> can see the whole). If I do nothing to the view and just save it, it
> errors on the field in the missing table. If I add the table in, it
> errors on another field that was/is in the field list. After the
> error, I keep getting the error when I try to modify the view. I
> can't get it open. This is a very compicated view that I do not wish
> to recreate. Any ideas?
>
> As a work around, can I add a field to the view programmatically with
> dbsetprop() . The field is in a table that already exists in the
> view.
>
> Thanks for your help.
>
> Cory Bonallo
> Developer

Anders
Wed Jan 12 16:34:15 CST 2005

Cory

You can extract the query with
x = DBGETPROP('viewname', 'VIEW', 'SQL')
DEBUGOUT x
You can then select and copy the string in the Debug Output window and paste
it into a program window. Edit it as you desire, then put CREATE VIEW xx AS
in front of the query and run this command.
You have to have the database open exclusivne to be able to update it.
If the query is short you can do
_Cliptext=DBGETPROP('viewname', 'VIEW', 'SQL')
and just hit Ctrl+V in the editing window.

-Anders

"Cory Bonallo" <coryb@jensenonline.com> wrote in message
news:eEW7ysO#EHA.3820@TK2MSFTNGP11.phx.gbl...
> I have a view that works just fine and has 4 tables in it joined together.
> If I open it in the view designer, one table is missing(you can see the
> whole). If I do nothing to the view and just save it, it errors on the
> field in the missing table. If I add the table in, it errors on another
> field that was/is in the field list. After the error, I keep getting the
> error when I try to modify the view. I can't get it open. This is a very
> compicated view that I do not wish to recreate. Any ideas?
>
> As a work around, can I add a field to the view programmatically with
> dbsetprop() . The field is in a table that already exists in the view.
>
> Thanks for your help.
>
> Cory Bonallo
> Developer
>
>

Cory
Wed Jan 12 17:01:19 CST 2005

VFP6.0
"Dan Freeman" <spam@microsoft.com> wrote in message
news:uXnQM6O%23EHA.1400@TK2MSFTNGP11.phx.gbl...
> What version of VFP?
>
> Recent versions have included MAJOR enhancements/changes in the view
> designer, so anyone approaching this needs to know what environment you're
> working in.
>
> Dan
>
> Cory Bonallo wrote:
> > I have a view that works just fine and has 4 tables in it joined
> > together. If I open it in the view designer, one table is missing(you
> > can see the whole). If I do nothing to the view and just save it, it
> > errors on the field in the missing table. If I add the table in, it
> > errors on another field that was/is in the field list. After the
> > error, I keep getting the error when I try to modify the view. I
> > can't get it open. This is a very compicated view that I do not wish
> > to recreate. Any ideas?
> >
> > As a work around, can I add a field to the view programmatically with
> > dbsetprop() . The field is in a table that already exists in the
> > view.
> >
> > Thanks for your help.
> >
> > Cory Bonallo
> > Developer
>
>

Cory
Wed Jan 12 17:23:33 CST 2005

Thanks! That's what I was looking for. Now I can work around the inherant
bugs in the view designer.
"Anders Altberg" <x_pragma@telia.com> wrote in message
news:e2W34ZP%23EHA.3124@TK2MSFTNGP11.phx.gbl...
> Cory
>
> You can extract the query with
> x = DBGETPROP('viewname', 'VIEW', 'SQL')
> DEBUGOUT x
> You can then select and copy the string in the Debug Output window and
paste
> it into a program window. Edit it as you desire, then put CREATE VIEW xx
AS
> in front of the query and run this command.
> You have to have the database open exclusivne to be able to update it.
> If the query is short you can do
> _Cliptext=DBGETPROP('viewname', 'VIEW', 'SQL')
> and just hit Ctrl+V in the editing window.
>
> -Anders
>
> "Cory Bonallo" <coryb@jensenonline.com> wrote in message
> news:eEW7ysO#EHA.3820@TK2MSFTNGP11.phx.gbl...
> > I have a view that works just fine and has 4 tables in it joined
together.
> > If I open it in the view designer, one table is missing(you can see the
> > whole). If I do nothing to the view and just save it, it errors on the
> > field in the missing table. If I add the table in, it errors on another
> > field that was/is in the field list. After the error, I keep getting
the
> > error when I try to modify the view. I can't get it open. This is a
very
> > compicated view that I do not wish to recreate. Any ideas?
> >
> > As a work around, can I add a field to the view programmatically with
> > dbsetprop() . The field is in a table that already exists in the view.
> >
> > Thanks for your help.
> >
> > Cory Bonallo
> > Developer
> >
> >
>

Anders
Wed Jan 12 19:53:29 CST 2005

Don't foreget to include REMOTE CONNECTION xx in the CREATE VIEW command.
It's also possible to USE the view with a connection string, but that may
not be as easy if tye view is opened in the Data Environment.
-Anders

"Cory Bonallo" <coryb@jensenonline.com> wrote in message
news:ePiO12P#EHA.3236@TK2MSFTNGP15.phx.gbl...
> Thanks! That's what I was looking for. Now I can work around the
inherant
> bugs in the view designer.
> "Anders Altberg" <x_pragma@telia.com> wrote in message
> news:e2W34ZP%23EHA.3124@TK2MSFTNGP11.phx.gbl...
> > Cory
> >
> > You can extract the query with
> > x = DBGETPROP('viewname', 'VIEW', 'SQL')
> > DEBUGOUT x
> > You can then select and copy the string in the Debug Output window and
> paste
> > it into a program window. Edit it as you desire, then put CREATE VIEW xx
> AS
> > in front of the query and run this command.
> > You have to have the database open exclusivne to be able to update it.
> > If the query is short you can do
> > _Cliptext=DBGETPROP('viewname', 'VIEW', 'SQL')
> > and just hit Ctrl+V in the editing window.
> >
> > -Anders
> >
> > "Cory Bonallo" <coryb@jensenonline.com> wrote in message
> > news:eEW7ysO#EHA.3820@TK2MSFTNGP11.phx.gbl...
> > > I have a view that works just fine and has 4 tables in it joined
> together.
> > > If I open it in the view designer, one table is missing(you can see
the
> > > whole). If I do nothing to the view and just save it, it errors on
the
> > > field in the missing table. If I add the table in, it errors on
another
> > > field that was/is in the field list. After the error, I keep getting
> the
> > > error when I try to modify the view. I can't get it open. This is a
> very
> > > compicated view that I do not wish to recreate. Any ideas?
> > >
> > > As a work around, can I add a field to the view programmatically with
> > > dbsetprop() . The field is in a table that already exists in the
view.
> > >
> > > Thanks for your help.
> > >
> > > Cory Bonallo
> > > Developer
> > >
> > >
> >
>
>

Fred
Wed Jan 12 23:27:44 CST 2005

You can just forget about hte view designer in VFP6 working correctly with
anything more than 1 table. Search for eView and use that instead. Here's
a link that should get you started:

http://fox.wikis.com/wc.dll?Wiki~eView~VFP

--
Fred
Microsoft Visual FoxPro MVP


"Cory Bonallo" <coryb@jensenonline.com> wrote in message
news:e$Tcy2P%23EHA.3236@TK2MSFTNGP15.phx.gbl...
> VFP6.0
> "Dan Freeman" <spam@microsoft.com> wrote in message
> news:uXnQM6O%23EHA.1400@TK2MSFTNGP11.phx.gbl...
>> What version of VFP?
>>
>> Recent versions have included MAJOR enhancements/changes in the view
>> designer, so anyone approaching this needs to know what environment
>> you're
>> working in.
>>
>> Dan
>>
>> Cory Bonallo wrote:
>> > I have a view that works just fine and has 4 tables in it joined
>> > together. If I open it in the view designer, one table is missing(you
>> > can see the whole). If I do nothing to the view and just save it, it
>> > errors on the field in the missing table. If I add the table in, it
>> > errors on another field that was/is in the field list. After the
>> > error, I keep getting the error when I try to modify the view. I
>> > can't get it open. This is a very compicated view that I do not wish
>> > to recreate. Any ideas?
>> >
>> > As a work around, can I add a field to the view programmatically with
>> > dbsetprop() . The field is in a table that already exists in the
>> > view.
>> >
>> > Thanks for your help.
>> >
>> > Cory Bonallo
>> > Developer
>>
>>
>
>

Dennis
Thu Jan 13 08:36:50 CST 2005

Fred,

"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:ud%23IaCT%23EHA.4004@tk2msftngp13.phx.gbl...
> You can just forget about hte view designer in VFP6 working correctly with
> anything more than 1 table.

<snipped>

I think you are wrong about this. I have designed views with the VFP 6.0
view designer using three tables with no problems. The problem I have found
with this view designer is that it will allow one to use subqueries in the
WHERE clause but once the view is saved it cannot be opened again in the
view designer. In fact, I suspect that is the problem that Cory was
experiencing. Frustrating to say the least, but I think your comment is a
bit of an overstatement.

<snipped>

I just want let you know that I almost read every post of yours in these
news groups and this is one of the very few times I have ever disagreed with
you. I have even used some of your ideas in my applications.

Finally, a question for you and the rest of the experts out here. Can the
view designer in later versions handle subqueries?

Keep up the good work and thanks,

Dennis Longfellow

Fred
Thu Jan 13 09:03:51 CST 2005

Yes, I was probably a bit over the top with "more than 1" comment, but I
just found the View Designer to not work in so many situations, I simply
gave up on ever trying to use it (and getting burned). Period. It has been
improved vastly in later versions of VFP.

--
Fred
Microsoft Visual FoxPro MVP


"Dennis Longfellow" <xxxdrlongfellowxxx@xxxdirectracx.xxx.com> wrote in
message news:eHSzT1X%23EHA.3376@TK2MSFTNGP12.phx.gbl...
> Fred,
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:ud%23IaCT%23EHA.4004@tk2msftngp13.phx.gbl...
>> You can just forget about hte view designer in VFP6 working correctly
>> with
>> anything more than 1 table.
>
> <snipped>
>
> I think you are wrong about this. I have designed views with the VFP 6.0
> view designer using three tables with no problems. The problem I have
> found
> with this view designer is that it will allow one to use subqueries in the
> WHERE clause but once the view is saved it cannot be opened again in the
> view designer. In fact, I suspect that is the problem that Cory was
> experiencing. Frustrating to say the least, but I think your comment is a
> bit of an overstatement.
>
> <snipped>
>
> I just want let you know that I almost read every post of yours in these
> news groups and this is one of the very few times I have ever disagreed
> with
> you. I have even used some of your ideas in my applications.
>
> Finally, a question for you and the rest of the experts out here. Can the
> view designer in later versions handle subqueries?
>
> Keep up the good work and thanks,
>
> Dennis Longfellow
>
>

Paul
Thu Jan 13 13:15:50 CST 2005

There's your problem.

The view designer back then was pretty limited. VFP8's was much better, and
VFP9's is better still.

Write a program to create the view. Change that program and rerun it when
you want to edit the view.


"Cory Bonallo" <coryb@jensenonline.com> wrote in message
news:e$Tcy2P%23EHA.3236@TK2MSFTNGP15.phx.gbl...
> VFP6.0
> "Dan Freeman" <spam@microsoft.com> wrote in message
> news:uXnQM6O%23EHA.1400@TK2MSFTNGP11.phx.gbl...
>> What version of VFP?
>>
>> Recent versions have included MAJOR enhancements/changes in the view
>> designer, so anyone approaching this needs to know what environment
>> you're
>> working in.
>>
>> Dan
>>
>> Cory Bonallo wrote:
>> > I have a view that works just fine and has 4 tables in it joined
>> > together. If I open it in the view designer, one table is missing(you
>> > can see the whole). If I do nothing to the view and just save it, it
>> > errors on the field in the missing table. If I add the table in, it
>> > errors on another field that was/is in the field list. After the
>> > error, I keep getting the error when I try to modify the view. I
>> > can't get it open. This is a very compicated view that I do not wish
>> > to recreate. Any ideas?
>> >
>> > As a work around, can I add a field to the view programmatically with
>> > dbsetprop() . The field is in a table that already exists in the
>> > view.
>> >
>> > Thanks for your help.
>> >
>> > Cory Bonallo
>> > Developer
>>
>>
>
>