Does anyone use SQL Explorer?

[Bill Thompson]

Does anyone use SQL Explorer just to execute on-the-fly SQL statements?

All of the examples everywhere are for other languages or tools that do an "EXEC SQL blah blah blah".

I can use SQL Explorer to do SELECT statements, CREATE USER, CREATE TABLE etc...

But I am getting nowhere trying to DECLARE A CURSOR. I get a syntax error on: DECLARE myCursor CURSOR select * from myTable;

What I would really like is to find a REFERENCE that sticks to PURE SQL 92 sql statements.

 

[regulatre]

There are several PDF/online/html manuals that cover that topic:

The general area for documentation is:
www.Progress.com
support
Resources
Documentation

Does anyone use SQL Explorer just to execute on-the-fly SQL statements?

All of the examples everywhere are for other languages or tools that do an "EXEC SQL blah blah blah".

I can use SQL Explorer to do SELECT statements, CREATE USER, CREATE TABLE etc...

But I am getting nowhere trying to DECLARE A CURSOR. I get a syntax error on: DECLARE myCursor CURSOR select * from myTable;

What I would really like is to find a REFERENCE that sticks to PURE SQL 92 sql statements.