Re: Database views

From: CM (CM_at_discussions.microsoft.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 09:49:04 -0700

Thanks again. I've been opening three views in work areas A, B and C, then
setting relations between A and B, performing some work, then between A and C
and performing some work. The purpose is to bring field values from a base
table in one database into a base table in another data base. Everything
seems to work fine.

I was not able to find documentation in the help files that expressly stated
I could index views and set relations between them, that's why I originally
posted my question.

I appreciate your taking the time to reply,

CM

"Stefan Wuebbe" wrote:

> > Why might the SET RELATION not be as reliable?
>
> That's a good question. I'd say Set Relation is more complicated because
> there are more things to care for - two or more record pointers, child index,
> grid's "link masters" and the relations themselves.
> In practice Vfp grids seem to handle views (representing several Joined
> tables) better - newsgroups are full of questions about Set Relation not
> immediately working in grids.
> Dataenvironments containing only one or three views are much easier to
> maintain than those containing some ten tables + relations.
>
>
> hth
> -Stefan
>
> "CM" <CM@discussions.microsoft.com> schrieb im Newsbeitrag
> news:4BB7DD6D-E40B-4DFE-8D85-BE63D6ACCBA5@microsoft.com...
> > Thanks. Why might the SET RELATION not be as reliable?
> >
> > CM
> >
> > "Stefan Wuebbe" wrote:
> >
> >>
> >> "CM" <CM@discussions.microsoft.com> schrieb im Newsbeitrag
> >> news:25B45F82-6DD3-4FAF-BE0F-B84B6859668B@microsoft.com...
> >> >I built my database with four tables linked via inner joins. Each table has
> >> > a primary key associated with it. When I build a view using fields from all
> >> > four tables, can I use the INDEX command on the view?
> >>
> >> Yes.
> >> (Indexing views only works temporarily at runtime though.)
> >>
> >> > Can I open another
> >> > database view, index it and SET RELATION to the first one based on this index?
> >>
> >> Yes.
> >> (But Set Relation may not work as reliable as a multi-join,
> >> in Vfp grids for example.
> >> Alternatively you could just create another view joining all
> >> tables together.)
> >>
> >>
> >> hth
> >> -Stefan
> >>
> >>
>
>

Loading