Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!sun-barr!decwrl!nsc!pyramid!infmx!randall
From: randall@informix.com (Randall Rhea)
Newsgroups: comp.databases
Subject: Re: Can one reference global vars in SQL stmts in ORACLE SQL*Forms?
Keywords: Oracle
Message-ID: <1990Sep25.001437.25041@informix.com>
Date: 25 Sep 90 00:14:37 GMT
References: <11212@spool.cs.wisc.edu> <1990Sep19.034626.23721@eagle.lerc.nasa.gov>
Sender: news@informix.com (Usenet News)
Organization: Informix Software, Inc.
Lines: 14

You CAN reference globals in version 3.0 of SQL*Forms, as long as you
use a PL/SQL trigger.  For example:

               SELECT cus_name
               FROM customers
               WHERE cus_id = :GLOBAL.cus_id;

However, you still cannot reference GLOBALs in the default WHERE/ORDER_BY
clause of a block, or in a list-of-values-SQL statement.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Randall Rhea                                          Informix Software, Inc. 
Senior Programmer/Analyst, MIS                    uunet!pyramid!infmx!randall