From: jstrange@tpd.dsccc.com (John Strange)
Newsgroups: comp.databases.oracle
Subject: Re: FORMS 3.0 Query Only Mode
Date: 2 Feb 1995 12:42:55 GMT
Organization: DSC Communications Corporation, Plano, Texas USA
Lines: 32
Message-ID: <3gqk0f$9fm@tpd.dsccc.com>
References: <1995Jan31.105339.20810@bilpin.co.uk>
NNTP-Posting-Host: mis.dsccc.com
X-Newsreader: TIN [version 1.2 PL2]


Tony Desborough (tony@bilpin.co.uk) wrote:
: Hi,
 
: Is there a quick an easy way to make a FORMS 3.0 form read-only? i.e
: the users can only do queries, but cannot insert, update or delete
: any records. Something like a command line option indicating read-only
: access would be great, and would save alot of work.
 
: Thanks in advance
: Tony
 
: -- 
: ----------------------------------------------------------------------------
: Tony Desborough                                                 SRL Data Ltd
: Software Programmer                                             1, Perren St
: Email: tony@bilpin.co.uk                                     LONDON, NW5 3ED 

--
If it is going to be from the command line the user could forget to add
the switch (if there is one); you would have to write a C program to launch
the form.
I have a menu of functions the user can select from in a form and for
query only functions I do a
	CALL_QUERY (form_name, other options here);

page 16-8 SQL*Forms Designer's Reference Version 3.0

------------------------------------------------------------------------
jstrange@ccmail.dsccc.com |  John Strange           | If frogs had wings
  214-519-3574            | DSC Communications Corp | they wouldn`t bump
--------------------------+ 600 Data Dr,  MS ISD07  | their butt as
I speak for me, not DSC.  | Plano, Tx 75075         | they hopped along.