<font size=2 face="sans-serif">oops this was the error </font>
<br>
<br>
<br><font size=2 face="Courier New">Reading report specifications and preparing
query . . .</font>
<br><font size=2 face="Courier New">E_US09C6 line 1, Syntax error on 'create'.
The correct syntax is:</font>
<br><font size=2 face="Courier New"> CREATE TABLE tablename</font>
<br><font size=2 face="Courier New"> [(columnname
{, ... })]</font>
<br><font size=2 face="Courier New"> AS subselect</font>
<br><font size=2 face="Courier New"> [with_clause]</font>
<br><font size=2 face="Courier New"> (Thu Feb 18 13:30:13
2016)</font>
<br>
<br><font size=2 face="Courier New">E_RW13EE Error in setup or cleanup
section found</font>
<br><font size=2 face="Courier New"> Statement in error was:</font>
<br><font size=2 face="Courier New"> ''</font>
<br>
<br><font size=2 face="Courier New">E_RW100A 1 error(s) have occurred in
setting up the report. No report will</font>
<br><font size=2 face="Courier New"> be written. Correct
errors and rerun.</font>
<br>
<br>
<br>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Allan Biggs <Allan.Biggs@GBR.dupont.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">info-ingres@lists.planetingres.org,
info-ingres-bounces@lists.planetingres.org</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">18/02/2016 12:38</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">[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><font size=2 face="Courier New">the following query works in SQL (isql)
but fails when run in report writer - does report writer use older version
of sql?</font><font size=3> <br>
<br>
</font><font size=2 face="Courier New"><br>
create table numreelsresults_w_rrp</font><font size=3> </font><font size=2 face="Courier New"><br>
as select nreels = count (distinct roll_number),</font><font size=3> </font><font size=2 face="Courier New"><br>
n_tests = count(test_res )</font><font size=3> </font><font size=2 face="Courier New"><br>
from</font><font size=3> </font><font size=2 face="Courier New"><br>
rxrpy_w_rrp;</font><font size=3> <br>
<br>
</font><font size=2 face="Courier New"><br>
thanks</font><font size=3> </font><font size=2 face="Courier New"><br>
Allan</font>
<p><font size=3><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.</font>
<p><font size=3>Francais Deutsch Italiano Espanol Portugues
Japanese Chinese Korean</font>
<p><font size=3> </font><a href=http://www.dupont.com/corp/email_disclaimer.html><font size=3>http://www.DuPont.com/corp/email_disclaimer.html</font></a><tt><font size=2>_______________________________________________<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>
<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> http://www.DuPont.com/corp/email_disclaimer.html</p>