File limit reached in Quick screen

Johnson, Harold A EDUC:EX Harold.A.Johnson@gems1.gov.bc.ca
Thu, 4 Nov 2004 09:13:09 -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_01C4C291.85228110
Content-Type: text/plain;
	charset="iso-8859-1"

(sry - meant to say "LIKE" not "LINK")
 

-----Original Message-----
From: Johnson, Harold A EDUC:EX 
Sent: 2004 November 4 9:07 AM
To: 'Paterson, Neil R SUKEP-EPT-IT-EA'; powerh-l@lists.sowder.com
Subject: RE: File limit reached in Quick screen


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_01C4C291.85228110
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=135531217-04112004><FONT face=Arial color=#0000ff size=2>(sry - 
meant to say "LIKE" not "LINK")</FONT></SPAN></DIV>
<DIV><SPAN class=135531217-04112004></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> Johnson, Harold A EDUC:EX 
  <BR><B>Sent:</B> 2004 November 4 9:07 AM<BR><B>To:</B> 'Paterson, Neil R 
  SUKEP-EPT-IT-EA'; powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: File limit 
  reached in Quick screen<BR><BR></FONT></DIV>
  <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></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C4C291.85228110--