Customer table most recent

Dmilesikhailov — Thu, 23 Jan 2020 03:44:48 GMT

How do I load the last few hundred rows from a QVD with over one million rows?

Customer:

Load *

;

SQL Select *

From tblCustomer

Re: Customer table most recent

jonathandienst — Thu, 23 Jan 2020 06:56:25 GMT

Something like this pattern:

Let vRowsToLoad = 200; Let vLimit = Alt(QvdNoOfRecords('SourceQVD.qvd'), 0); Let vStart = vLimit - vRowsToLoad - 1; Data: LOAD * FROM [SourceQVD.qvd] (qvd) Where RowNo() >= $(vStart);

Although this will scan the entire file, it should be reasonably quick -- a million rows is not a particularly large QVD.

Edit - fixed missing closing parenthesis.

topic Re: Customer table most recent in App Development

Customer table most recent

Re: Customer table most recent