Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Searching with PhDBase III
Message
De
22/01/2001 17:08:43
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Searching with PhDBase III
Divers
Thread ID:
00467010
Message ID:
00467010
Vues:
42
Two phdBase questions:

1) The phdbase documentation mentions that one can do a mixed PhDBase/VFP query, using native VFP indexes. However I can only seem to do "and" logic with the native indexes. For example, I can do:
phd("from vendors where <<(The New York Times)>> and (upper(vname))='NEW YORK' into cursor vlist").

I want to find all vendors which have NEW then YORK then TIMES, and I also want to get all vendors whose name starts with "NEW YORK". So this search will find "THE best NEW YORK steak house in TIMES square" but it won't find "NEW YORK TIMES", because I can't use OR.

I've found a way around it - run the first query as phd("from vendors <<*>> and (upper(vname))='NEW YORK'") following by phd("from vendors <> into cursor vlist"), but I want OR, because I want to search against other indexes.

PHDBASE is so powerful that I've been able to find other clever work arounds in how I index the tables, but I would love to have that OR capability.

2) If I index a table as follows: phd("index vname,keep all"), then I search for "<>", I don't get "DAVID MARLIN, INC." To get around this, I use a tagged search and search for "<>". Is there a way to tell phdbase to look for these short strings?

Thanks,

David
Répondre
Fil
Voir

Click here to load this message in the networking platform