Re: Query By Example in 4GL

> > 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 Andy, Not possible to do a) in v4.0 down but 4.1 does have this ability. b) can be done as you suggest by editing the WHERE clause returned by Construct. Cheers - Jim -------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 358-5911 (Work) Address: 1700 S. Amphlett Blvd. (415) 882-9728 (Home) San Mateo, CA 94402 Fax: (415) 571-6429 --------------------------------------------------------------------