<font size=2 face="sans-serif">Karl,</font>
<br>
<br><font size=2 face="sans-serif">You have been able to create tables
since , I think , version 6 (maybe 25 years ago??? :-) :-) :-)
) </font>
<br><font size=2 face="sans-serif">the report I have drops and creates
at least 5 tables - it just does not seem happy with count() - I use avg()
successfully </font>
<br>
<br><font size=2 face="sans-serif">thanks </font>
<br><font size=2 face="sans-serif">Allan</font>
<br>
<br>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Karl Schendel <schendel@kbcomputer.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">Ingres and related
product discussion forum <info-ingres@lists.planetingres.org></font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">18/02/2016 14:33</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">Re: [Info-ingres]
report writer question - query fails in RW but OK
in sql</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by:
</font><font size=1 face="sans-serif">info-ingres-bounces@lists.planetingres.org</font>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2><br>
> On Feb 18, 2016, at 9:24 AM, abc@google.com wrote:<br>
> <br>
> 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.<br>
> <br>
<br>
<br>
I would have thought that create table was allowed in a .SETUP section.<br>
It's been a long time for me as well, though, and I'm not in a position
right<br>
now to experiment.<br>
<br>
Maybe try declare global temporary table instead of create table?<br>
<br>
Karl<br>
<br>
_______________________________________________<br>
Info-ingres mailing list<br>
Info-ingres@lists.planetingres.org<br>
</font></tt><a href="http://lists.planetingres.org/mailman/listinfo/info-ingres"><tt><font size=2>http://lists.planetingres.org/mailman/listinfo/info-ingres</font></tt></a><tt><font size=2><br>
</font></tt>
<br><p><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</p>
<p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean</p>
<p> http://www.DuPont.com/corp/email_disclaimer.html</p>