Re: Database views

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

  • Next message: Stefan Wuebbe: "Re: Database views" 
    Date: Fri, 24 Sep 2004 18:07:02 -0700

    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
    >
    >

  • Next message: Stefan Wuebbe: "Re: Database views"

    Relevant Pages

    • Re: Database views
      ... >I built my database with four tables linked via inner joins. ... > a primary key associated with it. ... > database view, index it and SET RELATION to the first one based on this index? ...
      (microsoft.public.fox.vfp.dbc)
    • Re: vfp database to SQL
      ... "Is this possible without redesigning the whole software?" ... If your software is based on an xbase FP2 model with USE, SET RELATION and ... Creating the server database as a copy of the FoxPro tables and moving the ...
      (microsoft.public.fox.programmer.exchange)
    • Re: Create an MS Access Table in VB6
      ... actually be reasonable assuming people don't manually edit the database. ... if anyone has any more info on how to implement a foreign key ... Set relation = database.CreateRelation ...
      (microsoft.public.vb.general.discussion)
    • Re: Error with Set Relation To
      ... SET ORDER TO paynum IN Balance ... use a file 092606.tmp and wanna set relation to balance.dbf. ... SET RELA TO PAYNUM INTO BALANCE ... Keeps getting the error " Database Not Ordered " on SET RELATION ...
      (microsoft.public.fox.helpwanted)
    • Database views
      ... I built my database with four tables linked via inner joins. ... a primary key associated with it. ...
      (microsoft.public.fox.vfp.dbc)
    Loading