File limit reached in Quick screen

Johnson, Harold A EDUC:EX Harold.A.Johnson@gems1.gov.bc.ca
Thu, 4 Nov 2004 09:06:50 -0800


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C4C290.7214DCC0
Content-Type: text/plain;
	charset="iso-8859-1"

A great way of getting around this is to combine multiple tables/files into
one view if possible in the database and only reference that view in the
quick screen.  (works only if you are running powerhouse against a database
link Oracle RDB)    The 31 file limit has been around forever - can someone
comment on why this limit was never increased?    (a 256 file limit would be
great... <g>)
 

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Paterson, Neil R
SUKEP-EPT-IT-EA
Sent: 2004 November 4 8:34 AM
To: powerh-l@lists.sowder.com
Subject: File limit reached in Quick screen




Hi all, 

Tried to compile a Quick screen, but get the following error 
*E* Too many files specified. The limit per screen is 31 files. 

Is there workaround for this, any place where I can reset the limit or do I
have to try to rewrite this rather complex screen...

I'm running PowerHouse 8.19.D7 on a HP3000. 

Thanks in advance, 
Neil 


------_=_NextPart_001_01C4C290.7214DCC0
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>File limit reached in Quick screen</TITLE>

<META content="MSHTML 6.00.2800.1476" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=668110517-04112004><FONT face=Arial color=#0000ff size=2>A 
great way of getting around this is to combine multiple tables/files into one 
view if possible in the database&nbsp;and only reference that view in the quick 
screen.&nbsp; (works only if you are&nbsp;running powerhouse against a database 
link Oracle RDB)&nbsp;&nbsp;&nbsp; The 31 file limit has been around forever - 
can someone comment on why this limit was never increased?&nbsp;&nbsp;&nbsp; (a 
256 file limit would be great... &lt;g&gt;)</FONT></SPAN></DIV>
<DIV><SPAN class=668110517-04112004><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> 
  powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com]<B>On 
  Behalf Of </B>Paterson, Neil R SUKEP-EPT-IT-EA<BR><B>Sent:</B> 2004 November 4 
  8:34 AM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> File limit 
  reached in Quick screen<BR><BR></FONT></DIV><!-- Converted from text/rtf format --><BR>
  <P><FONT face=Arial size=2>Hi all,</FONT> </P>
  <P><FONT face=Arial size=2>Tried to compile a Quick screen, but get the 
  following error</FONT> <BR><FONT face=Arial size=2>*E* Too many files 
  specified. The limit per screen is 31 files.</FONT> </P>
  <P><FONT face=Arial size=2>Is there workaround for this, any place where I can 
  reset the limit or do I have to try to rewrite this rather complex 
  screen...</FONT></P>
  <P><FONT face=Arial size=2>I'm running PowerHouse 8.19.D7 on a HP3000.</FONT> 
  </P>
  <P><FONT face=Arial size=2>Thanks in advance,</FONT> <BR><FONT face=Arial 
  size=2>Neil</FONT> </P></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C4C290.7214DCC0--