Search code examples
viewopenedgeprogress-db

Coding View in Progress OpenEdge Database

I have started exploring Progress databases and I would like to ask if someone knows how I code a view (Like in SQL) in the OpenEdge Procedure Editor?

Solution

  • There are no views in Progress. Plenty of other things though, like FOR-statements, joins and other stuff.

    In an ABL-editor you can write:

    FOR EACH table1 NO-LOCK, EACH table2 NO-LOCK WHERE table2.id = table1.id:
  DISPLAY table1.field2 table2.field3 WITH FRAME frOne 20 DOWN.
END.

    However storing that as a "view" that you can query in the future is not something that is possible.

    Don't think about what's possible in SQL or not - you need to focus on Progress instead.