General information
Category:
Coding, syntax & commands
Renato,
Can you clarify why you don't want to use the TOP n clause? I'm not sure I understand your objection.
>hi to all,
>
>In a SELECT SQL written in Oracle you can insert in the where expression a clause to stop the query after to have found N records, and you can do this with :
>
>SELECT .... WHERE .... AND rownum <= 500
>
>Can I do this with FoxPro ?
>I don't want to use a TOP N because this before return all row and after count the rows.
>I'm looking for something that force the user to do a query with a normal return or a partial return (if the query return 10000 customer I think that the user will refine the query)
>
>TIA
>Renato
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