Re: Need help clearing Form fields in a QUERY

Posted in 1995

Jeremy Russell — 9 Jun 1995 09:57:07 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <3r87jp$k3u@firehose.mindspring.com> gregw@gtalumni.org writes: <snip > What do I need to do to clear out all the <joined> fields when I > do a query on the porder table? > I'm using Informix SE with no 4GL or ESQL available. If I understood correctly, the answer is to use 'QUERYCLEAR' in the ATTRIBUTES section like this: f123 = tab1.column = tab2.column, QUERYCLEAR; This asks ISQL to clear the contents of the field, which it doesn't usually do on a re-query usually. -- Jeremy L. Russell | jeremy@skills.demon.co.uk | Phone : +44 181 446 6481 SkillAdvance Ltd. | 100424.2437@compuserve.com | Fax : +44 181 446 9143