<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Arial",sans-serif;
color:#002060;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-US'>Hello Allan<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-US'>What version of Ingres are you running?<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-US'>Your sample query works for me in the Ingres 10S Community Edition, based off a table with a couple of integer columns.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-US'>Chris<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span lang=EN-US 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<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></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:#5F5F5F'>From: </span><span style='font-size:7.5pt;font-family:"Arial",sans-serif'>Karl Schendel <<a href="mailto:schendel@kbcomputer.com">schendel@kbcomputer.com</a>></span> <br><span style='font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F'>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">info-ingres@lists.planetingres.org</a>></span> <br><span style='font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F'>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:#5F5F5F'>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:#5F5F5F'>Sent by: </span><span style='font-size:7.5pt;font-family:"Arial",sans-serif'><a href="mailto:info-ingres-bounces@lists.planetingres.org">info-ingres-bounces@lists.planetingres.org</a></span> <o:p></o:p></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" noshade style='color:#A0A0A0' align=center></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">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">Info-ingres@lists.planetingres.org</a></tt><br></span><a href="http://lists.planetingres.org/mailman/listinfo/info-ingres"><tt><span style='font-size:10.0pt'>http://lists.planetingres.org/mailman/listinfo/info-ingres</span></tt></a><o:p></o:p></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.<o:p></o:p></p><p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean<o:p></o:p></p><p> <a href="http://www.DuPont.com/corp/email_disclaimer.html">http://www.DuPont.com/corp/email_disclaimer.html</a><o:p></o:p></p></div></body></html>