move the cursor to the next row
Next moves the row cursor maintained within result to the next row in the table.
If the new Row is a valid row containing table data, Next returns true. If the new row is beyond the end of the table, Next returns false.
In a newly created Result module the row cursor is on the row before the first row containing data. Therefore a call to Next is required to read data from the first row.
The row cursor can be moved back using the Previous command.
Create a Result.
driver ≔ DatabaseLoadDriver⁡:
conn ≔ driver:-OpenConnection⁡url,name,pass:res ≔ conn:-ExecuteQuery⁡SELECT name FROM animals:
Since Next must be called before the first row of data can be accessed, it works as the condition of a while loop.
Download Help Document
What kind of issue would you like to report? (Optional)
Thank you for submitting feedback on this help document. Your feedback will be used
to improve Maple's help in the future.