mysql.seekRow

Move the results cursor to a specific row in the results list.

mysql.seekRow(queryid, row)

A query ID, and a row number

0

mysql.seekRow(queryID, 2)

MySQL returns nothing from the mysql_data_seek call, which is what Frontier’s mysql.seekRow calls. So there’s no real point in doing any error checking here, although you might want to test the general MySQL error functions.

MySQL uses base-0 numbering while Frontier uses base-1. If you want MySQL to find the first row, pass 1 from Frontier. This routine will decrement the value, and see row 0 via the MySQL call.

Because there could be a LOT of rows in a results dataset, the value passed from Frontier can be a double (although conversion is done from regular integers and longs).

• mysql.clearQuery
• mysql.compileQuery
• mysql.easyQuery
• mysql.getAffectedRowCount
• mysql.getQueryInfo
• mysql.getQueryWarningCount
• mysql.getRow
• mysql.getSelectedRowCount

• mysql_data_seek API