Merging searches

[erne]

on 26-11-2004 15:49, jda at jda at his.com wrote:

>> My question is, what is the best (simplest and most efficient) way
>> to do this in Valentina 2?
>> 
> 
> Hm, let me propose an answer to my own question. How does this sound:
> 
> 1. Do a query and collect the RecIDs in an array.
> 2. Do another query, and see if the recID of each hit is already in
> the array or not. Then keep it or remove it (depending if the user is
> ANDing or ORing the groups).
> 3. Repeat until all groups are done.
> 4. Sort the array and remove duplicates.
> 5. Do a final query for all records by 'WHERE RecID = x OR RecID =
> y...', using the values in the array.
> 

what about "Where Recid in x, y..." ?


Cool Runnings,
Erne.

-- 
| e r |  Ernesto Giannotta
| n e |  Musical Box - a media store