Execute the set_skip stored procedure

This stored procedure set the number of rows to skip for all subsequent SELECT queries. It does not apply to other types of Microsoft SQL commands.

If you submit a Microsoft SQL command that normally returns 100 rows and the skip value is set to 20, then the Microsoft SQL command will return the last 80 rows. To reset the skip count, call the stored procedure with a skip value of 0.

The stored procedure returns the number of the rows which will now be skipped in all SELECT queries from the current connection.

Note: The row skipping functionality is only available for simple SELECT queries. If a query is submitted which is too complex for the Microsoft SQL Engine to apply the skip value, a message will be logged to the oasErrLog and no rows will be skipped.

This stored procedure is currently only used by easy eXtended Operator Station (ezXOS) to simulate Microsoft SQL data cursors. This is done to support paging through results on a "fast table" display. Use by other applications is discouraged.

ODBC Syntax

call set_skip(<skip_value>)

Example

call set_skip(10);

10

select ptnum, name from message;

ptnum name

11 rtu1

12 rtu2

13 rtu3

14 rtu4

15 rtu5

16 rtu6

17 rtu7

18 rtu8

19 rtu9

20 rtu10

…