limiting the number of rows in a resultset

evildruid

evildruid

New Member
i am using progress 83C and php and i am trying to limit the number of rows that is returned in a result set from a query. Is there an easy way to do this?

what i am looking for is something similar to mysql's limit feature. is there anything available?
 
not at all?

you mean i have to call the entire query and just scroll through the first 10 or so if i wanted 11-20?
 
Nope

Progress doesn't have a record limiter, so if you want 10 records of a million record resultset, you get a million records. I believe you can set a limit to the size of a query resultset, but it still will process through the entire million record resultset, especially if you do sorting on the results that can't be processed via an index.

A limit SQL keyword would be nice, but I doubt it's going to happen.
 
You must log in or register to reply here.
Back
Top