>Anyone know of a way to return the TOP N rows from an Oracle package. I have a package that will return a cursor back to VFP, but I can't figure out out to return just the TOP N rows. I need the solution to be for the Oracle side and not just returning the entire cursor to VFP then taking the first 100 records.
>
>TIA!
Add WHERE ROWNUM <= N to the select statement.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao