Marcin, Minor tweak => works! I also added DESC to retrieve the newest
records using the field key name (number is an auto increment).
`````````````````
"SELECT FIRST " + stNumOfRecordsToRetrieve + " * FROM " + stTableName +
" ORDER BY " + fstKeyID + " DESC";
`````````````````
It's interesting that the newest records are found first (DESC), then the
number of records retrieved are from those DESC record results.
`````````````````````````
On Thu, Dec 12, 2019 at 1:29 PM 'Marcin Bury' [email protected]
[firebird-support] <[email protected]> wrote:
>
>
> Hi
>
> SELECT FIRST 10 * FROM A_TABLE
>
> Should work
>
> Cheers
> Marcin
>
>
> ------ Wiadomość oryginalna ------
> Od: "Clyde Eisenbeis [email protected] [firebird-support]" <
> [email protected]>
> Do: [email protected]
> Data: 12.12.2019 19:59:44
> Temat: [firebird-support] How do I limit an SQL search list to 10 records?
>
> This finds all records:
> ``````````````````````````````````
> "SELECT * FROM " + stTableName
> ``````````````````````````````````
> This does not work:
>
> ``````````````````````````````````
> "SELECT * FROM " + stTableName + " FETCH 10 ROWS"
> ``````````````````````````````````
>
>
>
