Re: replace opnqryf with sql

[James Horn <jdhorn@xxxxxxxxxxxxxx>]

Another idea, especially if you want to leave your old report
programs almost unchanged, would be to use a special file(program) as your
input/primary.
You can generate an sql string, pass it to the special file program, and
have the special file program retrieve the data and return it 1 record at a
time so the cycle still works.

see   http://www.itjungle.com/fhg/fhg060607-story01.html

the report program can use externally defined files also.

Jim