Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview

Buy Now

Issue 20.6 ('Nashville 2022')
Instant purchase and download via GumRoad!


Using Limit and Offset

Limiting the number of retrieved rows returned

Issue: 20.6 (November/December 2022)
Author: Vince Du Beau
Author Bio: Vince is an experienced Filemaker developer. He is exploring XOJO as an alternative to Filemaker.
Article Description: No description available.
Article Length (in bytes): 4,849
Starting Page Number: 72
Article Number: 20609
Resource File(s):

Download Icon project 20609.zip Updated: 2022-10-31 22:45:45

Related Link(s): None

Excerpt of article text...

In the last two issues of xDev, my column showed me using the LIMIT SQL command. This column will go into more detail. Along with the corresponding OFFSET command. I am reproducing the code below as a reminder.

Define our ODBC database

Dim db As New ODBCDatabase

Dim SQL As Text // Field for the SQL statement

Dim dbCursor As Recordset // Query results

...End of Excerpt. Please purchase the magazine to read the full article.