Re: noentry field in ISQL FORMS... a question

This answer was sent directly to me, but it was Kate Juliff that asked the original question. } From tjc@umbra.pvh.org Mon Jan 29 16:26:18 1996 } Mime-Version: 1.0 (NeXT Mail 3.3 v118.2) } From: Teresa Crowl <tjc@umbra.pvh.org> } Date: Mon, 29 Jan 96 09:29:10 -0700 } To: Richard Thomas <rt10hp@csl.gov.uk> } Subject: Re: noentry field in ISQL FORMS... a question } } } } Begin forwarded message: } } From: Richard Thomas <rt10hp@csl.gov.uk> } Date: Thu, 25 Jan 1996 17:17:33 GMT } To: informix-list@rmy.emory.edu } Subject: Re: noentry field in ISQL FORMS... a question } Content-Md5: hVkdfsjsiKXkxyAF/y7KrQ== } Sender: informix-list-owner@rmy.emory.edu } Reply-To: Richard Thomas <rt10hp@csl.gov.uk> } X-Informix-List-To: tjc@umbra.pvh.org } X-Informix-List-Id: <list.8520> } } >If anyone does know of a way to do this, and can reply to this >message } >without once referring to 4gl, come on down :-) } } >INFORMIX: I know you've "given up" with isql development, but I get >the } >feeling that a lot of people are still using PERFORM and ACE, and my } >colleagues and I are making them do some pretty nifty stuff. There's } >probably loads of features we could request, but for starters, } how's >about } >"noquery". } } > Thanks in advance, } > Kate } > } } >Richard. } } } } } Try it this way using a LOOKUP/JOINING - (use one or multiple tables) } Heres my screen - } } PERFORM: Query Next Previous View Add Update Remove } Table... Searches the active database table. ** 1: employee table } ** } } last_name [CROWL ] } first_name [TERESA ] } middle_init [ ] } depart [INFO SYSTEMS ] } title PROGRAMMER ANALYST III } ss_number [###-##-####] } initials [tjc ] } job_class [683E ] } } And I define like this: } } { } last_name [f000 ] } first_name [f001 ] } middle_init [a] } depart [f002 ] } title [f003 ] } ss_number [f006 ] } initials [f008] } job_class [f014 ] } } } } end } tables } employee } attributes } f000 = employee.last_name; } f001 = employee.first_name; } a = employee.middle_init; } f002 = employee.depart; } f006 = employee.ss_number, } LOOKUP f003 = employee.title } JOINING employee.last_name; } f008 = employee.initials; } f014 = employee.job_class; } end } } Even though the column 'title' exists within the same employee } table - this is kind of a self join - } the data is displayed but can never be touched. } } Teresa }