Re: Need help clearing Form fields in a QUERY

Posted in 1995

Jeremy Russell — 12 Jun 1995 13:41:45 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <3r9alb$aul@cssun.mathcs.emory.edu> rt10hp@csl.gov.uk "Richard Thomas" writes: > >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. Yeah, that's the coding method for using different attributes on the field depending whether you are editing the master or detail table. For completeness, I'd use: f123 = tab1.column, QUERYCLEAR, NOENTRY, NOUPDATE; = tab2.column; which will protect the master table column value from being changed to disassociate it from its linked detail records. -- Jeremy L. Russell | jeremy@skills.demon.co.uk | Phone : +44 181 446 6481 SkillAdvance Ltd. | 100424.2437@compuserve.com | Fax : +44 181 446 9143