From: asiandoof@hotmail.com (CupOfWater) Newsgroups: comp.databases.oracle.tools Subject: Re: Persistant variable in Form 6i Date: 8 Aug 2001 10:39:26 -0700 Organization: http://groups.google.com/ Lines: 29 Message-ID: References: <997220476.23880.0.pluto.d4ee154e@news.demon.nl> <9kqsvr$tv$1@gate.local> NNTP-Posting-Host: 141.213.40.137 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 997292366 31743 127.0.0.1 (8 Aug 2001 17:39:26 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2001 17:39:26 GMT Thanks so much. The global variable and a pre-block trigger did the trick! Kevin richard@r-senior.demon.co.uk (Richard Senior) wrote in message news:<9kqsvr$tv$1@gate.local>... > In article <997220476.23880.0.pluto.d4ee154e@news.demon.nl>, > "Sybrand Bakker" writes: > > > > "CupOfWater" wrote in message > > news:e0c9495d.0108071309.70b1e7e3@posting.google.com... > >> wouldn't want the message to come up every single time. Is there a > >> way to create a persistance variable - a flag essentially that will > >> last for the execution of the form? > > > > Create a package with a variable defined in the package specification. > > Another way is to use a global variable in the form. These only allow you > to store character data up to 255 characters but they are visible across > all triggers in your form (in fact they are visible across different > modules in your runtime session too). There's no need to declare them, > just assign a value: > > :GLOBAL.message_displayed := 'TRUE'; > > You might also find the DEFAULT_VALUE builtin useful for giving global > variables a value if they are null, e.g. > > DEFAULT_VALUE('FALSE', 'GLOBAL.message_displayed');