Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Basic Questions
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00054586
Message ID:
00055742
Vues:
40
>Next Question -
>What’s the best way to limit data access depending on First 2 char?
>All P<--->>C keys (CC9999) start with
>‘MD’
>‘ST’ or
>‘TD’
>no filter for top management - AS IS would be fine!
>Maintaining about 1650 recs having 126 fields combined (includes 2 Memo).
>
>A) Create index filtered on both parent and child & use as relation.
>
>B) Delete DBC Relation and Create 3 View with it’s own D E.
>
>C) Create 3 Form’s (ignoring DBC relation) having own relation’s.
>
>D) A better way not mentioned above?
>Should I be starting a new thread for each question?
>Thanx - Ed B

A NO, I dislike filtered indexes because you need different indexes for each filter.

B Close (see D below)

C NO Too much overhead

D Use a parameterized view, where the parameter is the 2-char information. There are threads about parameterized views. If you haven't used one, then it's just a standard view, except in the WHERE clause you put a question mark in front of the variable on the right "WHERE Myfield = ?Myvar" When you load the view, if the program can't find MyVar it will ask you. Usually you set this value programatically. You WILL need an index on the field.

As for new threads, play it by ear. It's sometimes easier to follow several short threads if the topics are different. If it's more questions on the original topic, just extend the present thread.

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform