Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!munnari.oz.au!metro!bunyip!brolga!exnirad
From: exnirad@brolga.cc.uq.oz (Nirad Sharma)
Newsgroups: comp.databases
Subject: Re: sql*forms & multi-table queries
Message-ID: <.639611065@brolga>
Date: 8 Apr 90 21:44:25 GMT
References: <LAWHORN.90Apr6125922@optis31.uucp>
Sender: news@bunyip.cc.uq.oz.au
Distribution: comp
Lines: 20

lawhorn@optis31.uucp (Jeff Lawhorn) writes:

>I need to be able to do a query based on both the ship date and
>the item.  These are stored in 2 different tables (cust_info &
>order_info), and so far I have not been able to figure out how to
>do this query.  It is a simple join from sql, but the people that
>are going to be using this form have little to no knowlege of
>sql. 

Create a view in SQL*PLUS and then specify that view as the table for the
block in your form. It works fine for the queries (I assume you mean the
ENTQRY- & EXEQRY-type queries) that I have tried. I got problems with
updates to such a block, however. Something along the lines of "CANNOT RESERVE
RECORD". Any ideas ?


Nirad Sharma (exnirad@cc.uq.oz.au)
Continuing Education Unit
The University of Queensland
AUSTRALIA