<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Hi John:<BR>
<BR>
I don't see a reason for a second attach.<BR>
<BR>
Your PRIMARY and DESIGNER should be able to share the same attach.<BR>
<BR>
The underlining SQL should be able to handle a second OPEN CURSOR within<BR>
a FETCH NEXT loop.<BR>
<BR>
Regards,<BR>
Peter<BR>
<BR><BR><BR>
<BLOCKQUOTE>
<HR>
Date: Thu, 12 Jun 2008 08:33:07 -0700<BR>From: resolutebay@yahoo.com<BR>Subject: Table Alias'ing<BR>To: powerh-l@lists.sowder.com<BR><BR>
<DIV>Greetings Listers:</DIV>
<DIV> </DIV>
<DIV>I am under the impression/assumption that under the following conditions a second attach is made to the database: Powerhouse 7.10e DEC SQL V6.1-13:</DIV>
<DIV> </DIV>
<DIV>Example #1:</DIV>
<DIV> </DIV>
<DIV>FILE OBLIGATION ALIAS OB</DIV>
<DIV> </DIV>
<DIV>I assert that it's (almost) the same as:</DIV>
<DIV> </DIV>
<DIV>Example #2:</DIV>
<DIV> </DIV>
<DIV>FILE OBLIGATION DESIGNER</DIV>
<DIV> </DIV>
<DIV>FILE OBLIGATION designer alias obl</DIV>
<DIV> </DIV>
<DIV>where you must have two separate attaches.</DIV>
<DIV> </DIV>
<DIV>Can anyone please clear up any misapprehension? A colleague here says that the first is only a 'pointer' (his term) situation and no second attach happens.</DIV>
<DIV> </DIV>
<DIV>TIA</DIV>
<DIV> </DIV>
<DIV>JP</DIV>
<BR></BLOCKQUOTE><br /><hr /> <a href='' target='_new'></a></body>
</html>