Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Searching with PhDBase III
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement