Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field with several values
Message
 
À
16/06/1998 04:51:32
Misson Bernard
Cddp de L'Aisne
Laon, France
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00108553
Message ID:
00108589
Vues:
30
>How to indexe a field with several values (a slash with separator) ?
>Example : Author : Smith, J./James, H.

Good question. Wish I had a good answer... :-)

I don't know of any way to do this with a Fox index. You could try a product such as PhDbase (caps?) that does full-text searching, or change your data so that you have a table of books/articles, a table of authors, and a cross-reference table that links them.

As it stands, your table violates 'first normal form': I don't know if this is a concern for you. 1NF states that you cannot have repeating values in a field.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform