Path: utzoo!attcan!uunet!tut.cis.ohio-state.edu!usenet.ins.cwru.edu!eagle!news From: tprife@venus.lerc.nasa.gov (Mike Rife (Boeing)) Newsgroups: comp.databases Subject: Re: Can one reference global vars in SQL stmts in ORACLE SQL*Forms? Keywords: Oracle Message-ID: <1990Sep19.034626.23721@eagle.lerc.nasa.gov> Date: 19 Sep 90 03:46:26 GMT References: <11212@spool.cs.wisc.edu> Reply-To: tprife@venus.lerc.nasa.gov Organization: NASA Lewis Research Center Lines: 3 News-Software: VAX/VMS VNEWS 1.3-4 You can not reference globals in SQL trigger statements. What you want to do is copy the global into a temporary field on page 0 of the form and reference the temporary field.