OpenEdge 11.7 - offset not recognised - Forum - OpenEdge General - Progress Community

OpenEdge 11.7 - offset not recognised

 Forum

OpenEdge 11.7 - offset not recognised

This question is not answered

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
  • 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.