Re: Need help clearing Form fields in a QUERY

> In article <3r87jp$k3u@firehose.mindspring.com> gregw@gtalumni.org writes: > > 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. Greg, Jeremy, I'm sure somebody will correct me if I'm wrong, but don't you need something like: f123 = tab1.column, QUERYCLEAR; = tab2.column; I thought the join came after the semi-colon. Cheers, Richard. ----------------------------------------------------------------- | _ /\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | //\\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | -----------------------------------------------------------------