Dynamic Query Tool Kit

A set of routines to aid with developing software containing dynamic queries. It greatly simplifies coding and readability.

With Progress Version 9.1, a very powerful feature was added to the language – dynamic queries.

Great as they are – it takes a lot of work to make use of this new feature. It is the purpose of this tool kit to aid with simplifying dynamic queries for the developer.

The tool kit provides a set of functions that can be used to open, navigate, extract data from, and close dynamic queries in a straight forward and easy to use manner.
In my opinion it is the way it should have been done in the first place – but hey – gives me a chance to shine with my programming.

This tool kit should allow you to work in GUI, CHUI, WWW, and CLI based environments effortlessly.

One simple example to start with:

{dyntoolkit.i}

DEFINE VARIABLE h AS HANDLE NO-UNDO.

ASSIGN h = dyn_open("FOR EACH Job NO-LOCK").
DISPLAY cDyn_ErrCode cDyn_ErrMsg FORMAT "x(30)".
REPEAT:
   dyn_next(h).
   IF dyn_qoe(h) THEN LEAVE.
   DISPLAY dyn_getvalue(h, "Job.JobID")
           dyn_getvalue(h, "Job.Name")
           dyn_getvalue(h, "Job.Priority")
           dyn_getvalue(h, "Job.ErrCode").
END.
dyn_close(h).

** Where to find the package
http://www.oehive.org/amduus/DynToolKit/