RE: Access Client Solutions > Run SQL Scripts > Position to *Top or *Bot

There is a button below the result set that will pull in the entire set, it's just to the right of the date & time. Kind of looks like an arrow pointing down into a tray. If you want to interrupt it, you can - the button looks a little different while working.


There is nothing I know of to position to top or bottom as it does in STRSQL - oh, yeah, that's just like other list display screens. But Ctrl-Home and Ctrl-End will position you in however much of the result set you have.


Somewhat OT, but is you use the "Save results", it will save only what you've pulled so far, it doesn't automagically pull everything first.

Cheers
Vern


On Thu, 12 Jan, 2023 at 9:25 AM, Rob Berendt <rob@xxxxxxxxx> wrote:


To: midrange systems technical discussion

If the result set has more than a few hundred rows you have to hold it down indefinitely.

Try it with a simple select of the top member appearing in
select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER, NUMBER_ROWS
from qsys2.syspartitionstat
order by NUMBER_ROWS desc

Rob Berendt