Impromptu error message

[SAWYER, Anthony]

This is a multi-part message in MIME format.

------=_NextPartTM-000-bad1880c-5af2-4e35-b675-2515109269d2
Content-type: text/plain;	charset="iso-8859-1"

Hi Shirley,

The error appears to be an Oracle error rather than an inpromptu error.
I've got a set of manuals which gives the following explanation...

ORA-01468 a predicate may reference only one outer-joined table

Cause: A predicate in the WHERE clause has two columns from different tables
with "(+)". 

Action: Change the WHERE clause so that each predicate has a maximum of one
outer-join table.

I only have experience of Powerhouse 7 & 8, and not impromptu, but if this
error occurred in any Powerhouse code (QTP, Quiz or Quick) I would be sure
that it came from a view in the Oracle database rather than the code in the
module, as the sql cursors that can be built in powerhouse don't appear to
have the ability to use outer joins, and I am assuming that impromptu has
similar drawbacks in that area

Kind Regards

Tony Sawyer
Programmer
MFI Supply Chain Systems
Liliput Road
Northampton
NN1 7EY
(01604) 666830

-----Original Message-----
From: Shirley Phillips [mailto:SPhillips@contdisc.com]
Sent: 17 April 2002 02:35
To: 'powerh-l@lists.swau.edu'
Subject: Impromptu error message


Can someone explain what the following message means and how I can
troubleshoot my Impromptu report to find the offending column?:

           ORA-01468:  a predicate may reference only one outer-joined
table.

I have a file that I select one record from.  I have two other files that
are ailased multiple times to the one record file.  All aliased files are
related with an outer join to the one record file so I can retrieve the data
in the one record file if there is no matching data in some of the aliased
files.

Shirley Phillips
Information Systems Manager
Continental Disc Corporation
3160 W. Heartland Drive
Liberty, MO 64068
(816) 407-5562

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

------=_NextPartTM-000-bad1880c-5af2-4e35-b675-2515109269d2
Content-Type: text/plain;
	name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="InterScan_Disclaimer.txt"

The information in this e-mail is confidential and is intended solely for the use of the individual or entity to which it is addressed. Any views or opinions presented are those of the author and do not necessarily represent those of MFI Furniture Group PLC or its associated companies.

------=_NextPartTM-000-bad1880c-5af2-4e35-b675-2515109269d2--