Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!cs.utexas.edu!samsung!brutus.cs.uiuc.edu!wuarchive!decwrl!shlump.nac.dec.com!arkham.enet.dec.com!nmeser!may
From: may@28182.dec.com (Patrick May)
Newsgroups: comp.databases
Subject: Re: Oracle SQL*Forms Problem?
Message-ID: <174@arkham.enet.dec.com>
Date: 16 Mar 90 14:35:57 GMT
Sender: news@arkham.enet.dec.com
Distribution: usa
Organization: Digital Equipment Corporation
Lines: 22


In article <1990Mar15.170856.8924@pds3>, ravi@pds3 (Gorur R. Ravi) writes...
>I have an application which uses Oracle SQL*Forms. It is designed to
>consist of 6 pages (6 screens in different pages) all belonging to
>one block (Table). Now the problem is whenever one enters the query mode 
>in Pages 2 thro' 6 the (dumb?) SQL*Forms puts the user in Field 1 of
>Page 1. Is there a way to restrict users to the same page and preferably
>to the same field? I do not want to have 6 blocks, one for each page
>because I will then have the problem of coordinating these blocks after
>the query. We are using SQL*Forms ver. 2.3.16 running on Prime/Unix.
>Any help will be appreacited. Thanks.


Try defining a KEY-ENTQRY trigger that saves the current position, performs
the change to query mode, and returns to the saved position.  This is just
a guess, I haven't worked with Oracle in a few months.

------------------------------------------------------------------------
                              "A contract programmer is always intense."

may%nmeser.enet@decwrl.dec.com
..!decwrl!nmeser.enet!may