OpenEdge 11.7 - offset not recognised

Posted by alexandru.trasca on 12-Jul-2017 08:01

I'm having trouble executing the following sql query:

select *
from Candidate ORDER BY CandidateID
offset 3 rows fetch next 1 rows only.

All Replies

Posted by Brian K. Maher on 12-Jul-2017 09:10

You are trying to run that from the ABL Procedure Editor.  It only understands some very limited SQL89 stuff.  You need to find a tool (like WinSQL) that you would use to make an ODBC or JDBC connection to the database and run your queries from there.

This thread is closed