Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Searching with PhDBase III
Message
From
22/01/2001 17:08:43
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Searching with PhDBase III
Miscellaneous
Thread ID:
00467010
Message ID:
00467010
Views:
43
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
Reply
Map
View

Click here to load this message in the networking platform