Query By Example in 4GL
Posted in 1992
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
When one uses the CONSTRUCT command in 4GL it blanks the listed screen fields before allowing user input. Does anyone know of a means of avoiding this, or alternative ways of achieving the functionality below. a) To allow the user to edit his previously entered criteria (e.g. his first search returns far less than he expected) b) Use a QBE on two fields to search Table 1. Only if that fails search using the same values on table 2. One way I've thought of is to replace the Table 1 column names in the return field of the original CONSTRUCT. Informix 4GL V1.1 by the way, but V4.0 manuals don't look any different Thanks in Advance =============================================================================== "Disclaimer, witticism, political statement." Andy Watson - Consultancy Department - Siemens Nixdorf Information Systems Bracknell, England E-mail : A.Watson@siesoft.co.uk ===============================================================================