GetResultSets pagination

SOLVED

Is there a way to paginate the GetResultSets() function in boi? I'm thinking sort of like how in SQL, you can use OFFSET and LIMIT to divide the query results into multiple pages. Is there a way to do that with the GetResultSets() function?

  • +1
    verified answer

    I don't think there is anything built into the method to do that, there are the two arguments in which you can specify a BEGIN key and END key but that only works if you know what the data will be at each interval.  If using VBScript, you can take the results and use VBScript's Split function to create an array.  The character you need to split on is the SEP characters (ASCII 138), use the Chr function.  You could then use a For, Do Until or Do While loop structure to loop however you want to.