Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table without PK - do I need one for View?
Message
De
25/10/2001 12:04:37
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
25/10/2001 11:59:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00573010
Message ID:
00573245
Vues:
39
>>Nadya,
>>Read my reply to Hilmar. I'm not talking about filters but set key to or relation.
>>PS: I never (almost never) use filters.
>>Cetin
>
>Çetin (is this spelled correctly?),
>
>The framework I use, Visual Extend, automatically uses filters in two cases:
>
>
  • Parent-child forms, as mentioned in my previous posting, to show all "children" for one "parent". However, they recommend using views, for efficiency reasons. I agree in principle, but I only start using views if the underlying table has more than 20,000 records.
    >
    >
  • There is a standard dialog that lets the user filter records in the form. Fields (or, rather, expressions) from the Grid Columns are automatically made available to the user, as expressions for the filter.
    >
    >Hilmar.
    Yes spelling is exact (pronounced Chat in):)
    OK views make sense for single tables in cases when I cannot find a simple set key version:)
    Cetin
    Çetin Basöz

    The way to Go
    Flutter - For mobile, web and desktop.
    World's most advanced open source relational database.
    .Net for foxheads - Blog (main)
    FoxSharp - Blog (mirror)
    Welcome to FoxyClasses

    LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
  • Précédent
    Suivant
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform