Dymanic OPQRYF Source Entery Editor

[Guest.Visitor]

Has any one a source for an editor for entering OPNQRYF or SQL statment, this would be very helpfull for me. I'm trying to finsh coding very old Programmes becouse of year 2000 and have no time to code this module. thanks for any suggestion.

[Guest.Visitor]

Araya, I don't think I understand the question. Are looking for an SQL statement editor? If so you might want to check out the one that comes with Operations Navigator. If you are trying to reduce time keying statments, testing, correcting, etc. you could put the statements in a file and run them dynamically. That way you can cut your turn around quite a bit. The December issue of Midrange Computing has a module that will dynamically run a statement. Once a statement is run, you can fetch records into your input area. The article is called "Picklists on the Fly". David Morris

[Guest.Visitor]

David, What I'm trying to make things easy for the users to make their enteries througt "choiceon the Fly" . for example if the user want sent a Xmas Letter to all customer living in Zuerich, instead of typing all customer-Nr's he get's a window were he kann select all customer's throug Zip code.

[David Abramowitz]

Am I missing something here? What's wrong with SEU? Dave

[Guest.Visitor]

David, you are right, why not !!