PDA

View Full Version : Using the TOP syntax

adamski
10-06-03, 21:01
Was just wondering if anyone knew how to execute a pervasive statement with a syntax similar to a mysql query of

SELECT * FROM table LIMIT x,y

i want to query starting from row x with a limit of y results. I looked into TOP but it seems it will only limit the number of results and not the starting row.
mirtheil
10-06-03, 21:56
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.
adamski
10-07-03, 01:14
ok no worries. thanks for that.