KB-28784: Displaying a limited amount of records from the database in E3Browser.

Question:

How can I set up an E3Browser to display just the last 20 records stored in the database?

Solution:

You can set it up directly in the SQL query. If you are using an Access database, use TOP 20 command. Be sure to order the result in decreasing order.

 

Example of query:

SELECT TOP 20 Tablr.E3TimeStamp,Table.Field,Table.Field2
FROM Table
ORDER BY Table.E3timestamp DESC