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.
I believe VFP 9 gives you the flexibility of choosing the top N
records by either
- all records matching top N values (current way)
- only the top N records in your result set (new way)
Any VFP 9 beta testers care to comment?
Malcolm
PS: Sorry - no idea how to do this under Oracle.
©2004 Malcolm Greene |
