It's the wording: "TOP 3" is what you said, but not what you get. Maybe
better to add a modifer, such as "TOP 3 [ONLY|ALL]" so when we want 3
and only 3, we get 3. True, by saying "only", you'd have to be aware of
how it works, and that you'll be getting only the first three records at
the top after a sort, which is probably random. But, still, sometimes
all you want is 3 exactly records, and if more are returned, you have to
fuss.
Bill
> > BTW, one of the mysteries of VFP is that when you SELECT TOP 3, you
> > can get a bunch more records in the result set than 3, if they have
> > matching values in the ORDER BY field. I think that's wrong.
>
> So if there are 2,000,000 records that match your
> criteria, how do you determine which are the top 3?
>
> ___/
> /
> __/
> /
> ____/
> Ed Leafe
©2004 Bill Arnold |
