<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7036.0">
<TITLE>RE: SQL - declare ... Cursor command in qdesign</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Well</FONT></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"> <FONT COLOR="#0000FF" FACE="Courier New">that</FONT></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New"> answers my previous email</FONT></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">; does that mean that you have to pass in the selection parameters from the previous screen ?</FONT></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Courier New">-----Original Message-----<BR>
From: Johnson, Harold A EDUC:EX [<A HREF="mailto:Harold.A.Johnson@gov.bc.ca">mailto:Harold.A.Johnson@gov.bc.ca</A>]<BR>
Sent: 04 December 2006 17:15<BR>
To: Joe Boyle; powerh-l@lists.sowder.com<BR>
Cc: lhoar@shaw.ca<BR>
Subject: RE: SQL - declare ... Cursor command in qdesign</FONT></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Thnx for the tips, we now have it working. We had to force a retrieval</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">in the initialize procedure in order to get the proper values, the auto</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">retrieval didn't work. </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">cheers</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New"> </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">-----Original Message-----</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">From: Joe Boyle [<A HREF="mailto:atla38@dsl.pipex.com">mailto:atla38@dsl.pipex.com</A>] </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Sent: Thu, November 30, 2006 4:33 PM</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">To: Johnson, Harold A EDUC:EX; powerh-l@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Subject: RE: SQL - declare ... Cursor command in qdesign</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">How about adding something like 'where (productid >= :tnum)' to your</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">cursor and add syntax to prompt for tnum, either via the access</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">statement, in the postpath proc, or ammend the path proc...</FONT></SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">-----Original Message-----</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">From: powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">[<A HREF="mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com">mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</A>] On</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Behalf Of Johnson, Harold A EDUC:EX</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Sent: 30 November 2006 20:15</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">To: powerh-l@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Subject: RE: SQL - declare ... Cursor command in qdesign</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Although we now don't get the error, we can't get a drop down to work</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">properly using subsitution. Only if we hard code the selection from the</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">table does it work. How do we get a run time selection to work in PH</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">web using cursors?</FONT></SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Thnx</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New"> </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">-----Original Message-----</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">From: Joe Boyle [<A HREF="mailto:atla38@dsl.pipex.com">mailto:atla38@dsl.pipex.com</A>]</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Sent: Thu, November 30, 2006 10:13 AM</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">To: Johnson, Harold A EDUC:EX; powerh-l@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Subject: RE: SQL - declare ... Cursor command in qdesign</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">I have the note below but can't recall where it came from originally,</FONT></SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">By specifying RDB/VMS versus RDB as the relational type, you specify how</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">the database is accessed and what PowerHouse capabilities are available.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Using RDB/VMS, the database is accessed via the native API, while RDB</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">specifies an SQL interface using the PowerHouse data access layer.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">RDB/VMS is essentially the same interface and feature set as in</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">PowerHouse 7.10. Using RDB allows you to use SQL statements and</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">SQL-related syntax such as the DECLARE CURSOR and CURSOR statements and</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">the SQL-related verbs. Since the two interfaces are quite different,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">there will likely be performance differences, however which will be</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">faster is situation dependant.</FONT></SPAN></P>
<BR>
<BR>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">-----Original Message-----</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">From: powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">[<A HREF="mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com">mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</A>] On</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Behalf Of Johnson, Harold A EDUC:EX</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Sent: 30 November 2006 17:57</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">To: powerh-l@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Subject: SQL - declare ... Cursor command in qdesign</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Hi all. We are operating on Alpha servers with OpenVMS, v8.2, PH</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">v840d1, using PH Web as an interface. We encountered an error when</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">attempting to use the SQL - declare cursor command:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Ie: sql in <database> declare <name> cursor for select * from</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New"><table>....</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">*E* The database 'SFAS_DATABASE' is the wrong type.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Our database type is "RDB/VMS", which is the preferred type as I</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">understood. However, when I changed the type back to just plain old</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">"RDB", the error went away. </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Is this on purpose, or is the "RDB/VMS" type just missing from the error</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">check?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Cheers</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">--</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">powerh-l@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Subscribe: &quot;subscribe&quot; in message body to</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">powerh-l-request@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">powerh-l-request@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New"><A HREF="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">This list is closed, thus to post to the list you must be a subscriber.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Add 'site:lists.sowder.com powerh-l' to your search terms to search the</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">list archive at Google.</FONT></SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">--</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">powerh-l@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Subscribe: &quot;subscribe&quot; in message body to</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">powerh-l-request@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">powerh-l-request@lists.sowder.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New"><A HREF="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">This list is closed, thus to post to the list you must be a subscriber.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">Add 'site:lists.sowder.com powerh-l' to your search terms to search the</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT COLOR="#0000FF" FACE="Courier New">list archive at Google.</FONT></SPAN></P>
</BODY>
</HTML>