Impromptu-Using SQL

[Oswald, Jeff]

What do you mean by "won't let you create an SQL statement"?

If the problem is that you don't have an EDIT button to click on, then the
user class that you are using does not have Edit SQL enabled.

Or are you saying that you have the button, but on the report that you are
trying to EDIT the SQL on does not allow this - i.e. it returns an error
message?  If so, there is a good chance that the report you are working is
doing things that are more than the SQL that you see and therefore will not
allow the visible SQL to be edited.


Jeffrey H Oswald                               Jeff.Oswald@Cognos.com
Sr. Technical Advisor                              joswald@acm.org
Cognos Services


----------
From: 	BRUCE ALLEN[SMTP:BALLEN@alpsnet.com]
Sent: 	Thursday, April 02, 1998 3:15 PM
To: 	powerh-l@lists.swau.edu
Subject: 	Impromptu-Using SQL

I am using Impromptu over dBase files.  In the profile of the query for a
report, it won't let me create an SQL statement.  Is this because I am
doing something wrong or because I'm using dBase.  I am the supervisor
and I checked and have rights to do this.

TIA
Bruce
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.