Qdesign enhancement - Required Secondary file

[Deskin, Bob]

I understand that you'd like to use a common set of functions, but we
were there first :-)
 
Seriously, are there SQL functions that don't have PowerHouse
equivalents? Keep in mind that we're not using pure SQL but a Cognos
version of it. Our middleware must allow the functions and then passes
them on to the database.
 
I'd like to make sure I understand the passed in values request. Can you
elaborate?
 
As for the left hand functions, that's because of the way our parser was
designed (>25 years ago). A few years ago, we looked at it again but
found that it got confused if we allowed expressions on the left. And at
this point, we don't want to introduce something new at that fundamental
a level and risk stability.
 
CSV is still on the table but don't hold your breath. One of the reasons
for the dearth of QUIZ enhancements is the prevalence of reporting
options from relational databases. Also, we are constrained by the
architecture.
 
By the way, it's easy to output a pdf report in QUIZ for Windows. Simply
get hold of one of the pdf printer drivers, such as PDFCreator at
sourceforge.org, and use it in the string following SET REPORT DEVICE
PRINTER.
 
Bob

	-----Original Message-----
	From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On
Behalf Of Darren Reely - Lists
	Sent: June 6, 2007 3:24 PM
	To: powerh-l at lists.sowder.com
	Subject: Re: Qdesign enhancement - Required Secondary file
	
	
	Me to. 

	More interesting feature additions from my experience is the
ability to use native SQL functions for the DB engine I'm using, or an
_easy_ way to add functions that would be useable from Quick, Quiz, and
QTP.

	Local scope variables.

	Another one is the ability to use a passed in value to a screen
as the input for a fetch, when that value is passed as opposed to empty,
otherwise allow for interactive user input.

	My favorite is that you can't have left sided evaluations;

	define x = value if function1() = function2()

	You have to do;

	define z = funciton1()
	define x = value if z = function2()


	As far as HTML support, Quiz seems the natural place to start as
its output can be used almost anywhere. Also recall our recent CSV file
discussion. Perhaps dump Quiz for ReportNet.


	On Jun 6, 2007, at 9:22 AM, Pickering, John (NORBORD) wrote:


		>A new option (REQUIRED) to a secondary file that would
NOT generate the OPTIONAL in the generated FIND procedure.

		

		Me too. Me too. Me too.
 
     This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070606/032455e8/attachment.htm