There is no LIMIT syntax in Pervasive.SQL. You can, if you're using V8, us the TOP statement and a WHERE clause to set the start row. Something similar to:
SELECT top X FROM table WHERE field=Y
Also, if you really need this syntax contact Pervasive to tell them you need it.
Hope this helps.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.