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

[Chris Rogers]

Hello Allan

 

What version of Ingres are you running?

 

Your sample query works for me in the Ingres 10S Community Edition, based
off a table with a couple of integer columns.

 

 

Chris

 

From: info-ingres-bounces at lists.planetingres.org
[mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of Allan Biggs
Sent: 18 February 2016 14:41
To: schendel at kbcomputer.com
Cc: Ingres and related product discussion forum
<info-ingres at lists.planetingres.org>; openroad-users at googlegroups.com;
info-ingres-bounces at lists.planetingres.org
Subject: Re: [Info-ingres] report writer question - query fails in RW but OK
in sql

 

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
<mailto:schendel at kbcomputer.com> > 
To:        Ingres and related product discussion forum
<info-ingres at lists.planetingres.org
<mailto: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
<mailto:info-ingres-bounces at lists.planetingres.org>  

  _____  





> On Feb 18, 2016, at 9:24 AM, abc at google.com <mailto: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
<mailto:Info-ingres at lists.planetingres.org> 
 <http://lists.planetingres.org/mailman/listinfo/info-ingres>
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/0de46a12/attachment.html>