[Info-ingres] report writer question - query fails in RW but OK in sql

[Allan Biggs]

Karl,

You have been able to create tables since , I think , version 6 (maybe 25 
years ago???  :-) :-) :-)   ) 
the report I have drops and creates at least 5 tables - it just does not 
seem happy with count() - I use avg() successfully 

thanks 
Allan





From:   Karl Schendel <schendel at kbcomputer.com>
To:     Ingres and related product discussion forum 
<info-ingres at lists.planetingres.org>
Date:   18/02/2016 14:33
Subject:        Re: [Info-ingres] report writer question - query fails in 
RW but OK       in sql
Sent by:        info-ingres-bounces at lists.planetingres.org




> On Feb 18, 2016, at 9:24 AM, abc at google.com wrote:
> 
> It's been many years since I used Report Writer, but I don't believe 
you're allowed to create tables within it.   You need to write a select 
statement to get the data.  You can do the create stuff using a script 
outside report writer to create a temp table.  Then query the temp table 
in the Report Writer script.
> 


I would have thought that create table was allowed in a .SETUP section.
It's been a long time for me as well, though, and I'm not in a position 
right
now to experiment.

Maybe try declare global temporary table instead of create table?

Karl

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres


This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean

          http://www.DuPont.com/corp/email_disclaimer.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20160218/b0b5da40/attachment.html>