Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Hi Fabio,
>if you want resolve the problem for match and not match condition,
>then resolve for N items not for 7 items.
Of course you can, then you've got to use a second NOT IN (SELECT ... FROM ... GROUP BY ... HAVING COUNT(*) > nNumber) etc.
Look I did not say that your solution is not right. I said, it indeed was a good one (and I really meant that). However there are some differences in the approaches which I wanted to list.
>Your solution is not usable with more of 7 items.
Actually it is 9 (maximum of 9 EXIST clauses in VFP8).
>- for States ( more 200 items ) condition, what do you do.
>- for 100000 items ?
I think in these extreme cases you have to look really well about performance penalties becauses you're talking about a lot of potential records and hardly can avoid full table scans. Note that your solution is also limited (to 24 items) unless you choose to join it with a custom cursor.
>If you want to have reason, then you have reason.
There is no need to be picky, I'm just trying to be constructive.
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only