Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!mips!daver!kcdev!genco!rad
From: rad@genco.uucp (Bob Daniel)
Newsgroups: comp.databases
Subject: Re: Can one reference global vars in SQL stmts in ORACLE SQL*Forms?
Message-ID: <31@genco.uucp>
Date: 11 Sep 90 14:26:45 GMT
References: <11212@spool.cs.wisc.edu>
Reply-To: rad@genco. (Bob Daniel)
Organization: Gentry & Assoc. Excelsior Springs, MO
Lines: 22

In article <11212@spool.cs.wisc.edu> beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) writes:
>
>   In one of my triggers I have an SQL statement that refers to a
>   global var:
>
>	  
>	  SELECT atom_numb, atom_name
>	  INTO   poss_atoms.atom_numb, poss_atoms.atom_name
>	  FROM   atom_lookup
>	  WHERE atom_lookup.nucleus = global.curr_nucleus;

Are you using Forms 3.0?  Did you use a : infront of global?  Also, try
using the NAME_IN package: (I'm not sure about this but may be worth a try.)

          WHERE atom_lookup.nucleus = NAME_IN('global.curr_nucleus');

Another method is to have a dummy field in a block and assign the global
to the dummy: (This one should work)
  
          :block.dummy := :global.curr_nucleus;
          <select statement>
          where atom_lookup.nucleus = :block.dummy;