Progress equivalient to LIMIT clause

[Tom2010]

Hi,

I need to page through a table. Normally in something like MySQL I would do something like

SELECT * FROM

WHERE [condition] LIMIT [start],[n]

I would then in whatever scripting language it is increment start multi times until there were no more records. Thereby I could say deliver 50 records at a time to the user.

How would you do this in Progress as it does not appear to have the LIMIT syntax available?

Thanks

Tom

 

[tamhas]

If you have a sufficiently modern version of Progress, TOP is supported. That and including a pointer to the last record from the prior query can get you there.