Re: Database views

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Stefan Wuebbe (stefan.wuebbe_at_gmx.de)
Date: 09/24/04

  • Next message: CM: "Re: Database views" 
    Date: Fri, 24 Sep 2004 08:17:54 +0200

    "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: CM: "Re: Database views"

    Relevant Pages

    • Re: Database views
      ... Why might the SET RELATION not be as reliable? ... >>I built my database with four tables linked via inner joins. ... >> 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)
    • Database views
      ... I built my database with four tables linked via inner joins. ... a primary key associated with it. ...
      (microsoft.public.fox.vfp.dbc)
    • 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)