<html><head>
<style><!--p.MsoNormal, li.MsoNormal, div.MsoNormal {
margin: 0.0cm;
font-size: 12.0pt;
font-family: "Times New Roman" , serif;
}
a:link, span.MsoHyperlink {
color: blue;
text-decoration: underline;
}
a:visited, span.MsoHyperlinkFollowed {
color: purple;
text-decoration: underline;
}
p {
margin-right: 0.0cm;
margin-left: 0.0cm;
font-size: 12.0pt;
font-family: "Times New Roman" , serif;
}
tt {
font-family: "Courier New";
}
span.EmailStyle19 {
font-family: Arial , sans-serif;
color: rgb(0,32,96);
font-weight: normal;
font-style: normal;
}
*.MsoChpDefault {
font-family: Calibri , sans-serif;
}
div.WordSection1 {
page: WordSection1;
}
--></style>
<meta name="viewport" content="width=device-width" /><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /></head><body link="blue" vlink="purple">Sorry everyone. .. I forgot to say I probably fixed it ... too embarrassed to admit what it could have been. <br>
For other reasons I split the setup section out into SQL as a future requirement needs 2 setups but the same report. <br>
<br>
Again <br>
Sorry <br>
-- <br>
Sent from my Android phone with <a href="http://mail.com">mail.com</a> Mail. Please excuse my brevity.<br><br><div class="gmail_quote">Chris Rogers <rogch01@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="WordSection1">
<p class="MsoNormal">
<span style="font-family: Arial , sans-serif;color: rgb(0,32,96);">Hello Allan</span>
</p>
<p class="MsoNormal">
<span style="font-family: Arial , sans-serif;color: rgb(0,32,96);"> </span>
</p>
<p class="MsoNormal">
<span style="font-family: Arial , sans-serif;color: rgb(0,32,96);">What version of Ingres are you running?</span>
</p>
<p class="MsoNormal">
<span style="font-family: Arial , sans-serif;color: rgb(0,32,96);"> </span>
</p>
<p class="MsoNormal">
<span style="font-family: Arial , sans-serif;color: rgb(0,32,96);">Your sample query works for me in the Ingres 10S Community Edition, based off a table with a couple of integer columns.</span>
</p>
<p class="MsoNormal">
<span style="font-family: Arial , sans-serif;color: rgb(0,32,96);"> </span>
</p>
<p class="MsoNormal">
<span style="font-family: Arial , sans-serif;color: rgb(0,32,96);"> </span>
</p>
<p class="MsoNormal">
<span style="font-family: Arial , sans-serif;color: rgb(0,32,96);">Chris</span>
</p>
<p class="MsoNormal">
<span style="font-family: Arial , sans-serif;color: rgb(0,32,96);"> </span>
</p>
<p class="MsoNormal">
<b><span style="font-size: 11.0pt;font-family: Calibri , sans-serif;">From:</span></b><span style="font-size: 11.0pt;font-family: Calibri , sans-serif;"> info-ingres-bounces@lists.planetingres.org [mailto:info-ingres-bounces@lists.planetingres.org]<b> On Behalf Of</b> Allan Biggs<br />
<b>Sent:</b> 18 February 2016 14:41<br />
<b>To:</b> schendel@kbcomputer.com<br />
<b>Cc:</b> Ingres and related product discussion forum <info-ingres@lists.planetingres.org>; openroad-users@googlegroups.com; info-ingres-bounces@lists.planetingres.org<br />
<b>Subject:</b> Re: [Info-ingres] report writer question - query fails in RW but OK in sql</span>
</p>
<p class="MsoNormal">
</p>
<p class="MsoNormal">
<span style="font-size: 10.0pt;font-family: Arial , sans-serif;">Karl,</span><br />
<br />
<span style="font-size: 10.0pt;font-family: Arial , sans-serif;">You have been able to create tables since , I think , version 6 (maybe 25 years ago??? :-) :-) :-) )</span><br />
<span style="font-size: 10.0pt;font-family: Arial , 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</span><br />
<br />
<span style="font-size: 10.0pt;font-family: Arial , sans-serif;">thanks</span><br />
<span style="font-size: 10.0pt;font-family: Arial , sans-serif;">Allan</span><br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: 7.5pt;font-family: Arial , sans-serif;color: rgb(95,95,95);">From: </span><span style="font-size: 7.5pt;font-family: Arial , sans-serif;">Karl Schendel <<a href="mailto:schendel@kbcomputer.com" target="_blank">schendel@kbcomputer.com</a>></span><br />
<span style="font-size: 7.5pt;font-family: Arial , sans-serif;color: rgb(95,95,95);">To: </span><span style="font-size: 7.5pt;font-family: Arial , sans-serif;">Ingres and related product discussion forum <<a href="mailto:info-ingres@lists.planetingres.org" target="_blank">info-ingres@lists.planetingres.org</a>></span><br />
<span style="font-size: 7.5pt;font-family: Arial , sans-serif;color: rgb(95,95,95);">Date: </span><span style="font-size: 7.5pt;font-family: Arial , sans-serif;">18/02/2016 14:33</span><br />
<span style="font-size: 7.5pt;font-family: Arial , sans-serif;color: rgb(95,95,95);">Subject: </span><span style="font-size: 7.5pt;font-family: Arial , sans-serif;">Re: [Info-ingres] report writer question - query fails in RW but OK in sql</span><br />
<span style="font-size: 7.5pt;font-family: Arial , sans-serif;color: rgb(95,95,95);">Sent by: </span><span style="font-size: 7.5pt;font-family: Arial , sans-serif;"><a href="mailto:info-ingres-bounces@lists.planetingres.org" target="_blank">info-ingres-bounces@lists.planetingres.org</a></span>
</p>
<div align="center" class="MsoNormal" style="text-align: center;">
<hr align="center" noshade="" size="2" style="color: rgb(160,160,160);" width="100%" />
</div>
<p class="MsoNormal" style="margin-bottom: 12.0pt;">
<br />
<br />
<br />
<span style="font-size: 10.0pt;font-family: "Courier New";"><br />
<tt>> On Feb 18, 2016, at 9:24 AM,<a href="mailto:abc@google.com" target="_blank"> abc@google.com</a> wrote:</tt><br />
<tt>></tt><br />
<tt>> 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.</tt><br />
<tt>></tt><br />
<br />
<br />
<tt>I would have thought that create table was allowed in a .SETUP section.</tt><br />
<tt>It's been a long time for me as well, though, and I'm not in a position right</tt><br />
<tt>now to experiment.</tt><br />
<br />
<tt>Maybe try declare global temporary table instead of create table?</tt><br />
<br />
<tt>Karl</tt><br />
<br />
<tt>_______________________________________________</tt><br />
<tt>Info-ingres mailing list</tt><br />
<tt><a href="mailto:Info-ingres@lists.planetingres.org" target="_blank">Info-ingres@lists.planetingres.org</a></tt><br />
</span><a href="http://lists.planetingres.org/mailman/listinfo/info-ingres" target="_blank"><tt><span style="font-size: 10.0pt;">http://lists.planetingres.org/mailman/listinfo/info-ingres</span></tt></a>
</p>
<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>
<a href="http://www.DuPont.com/corp/email_disclaimer.html" target="_blank"> http://www.DuPont.com/corp/email_disclaimer.html</a>
</p>
</div>
_______________________________________________ Info-ingres mailing list Info-ingres@lists.planetingres.org<a href="http://lists.planetingres.org/mailman/listinfo/info-ingres" target="_blank"> http://lists.planetingres.org/mailman/listinfo/info-ingres</a>
</blockquote></div></body></html>