TOP clause in SQL

rbuser

Dear all,

I need to make a report thats fetch only the first 50 registers from a
database. How can I put the TOP clause in my SQL sentence?

regards

Eduardo Romeiro
Athena Recursos Naturais
www.athenasoft.com.br

digitalmetaphors

The RB query tools don't support this syntax. You'll have to implement this
by editing the SQL text of the query dataview. You'll lose the query tools
support if the SQL is manually edited on the dataview. You can edit the SQL
text at runtime is you do not want to edit it when using DADE visually. Here
is an example of modifying the SQL text directly for report generation:

http://www.digital-metaphors.com/tips/EditSQLAndSearch.zip

Cheers,

Jim Bennett
Digital Metaphors