<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: SQL - declare ... Cursor command in qdesign</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2995" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=247373717-04122006><FONT face=Arial
color=#0000ff size=2>That appears to be the case, although we were stratching
our heads over this.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=247373717-04122006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=247373717-04122006><FONT face=Arial
color=#0000ff size=2>cheers</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=247373717-04122006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Joe Boyle [mailto:atla38@dsl.pipex.com]
<BR><B>Sent:</B> Mon, December 4, 2006 9:24 AM<BR><B>To:</B> Johnson, Harold A
EDUC:EX; powerh-l@lists.sowder.com<BR><B>Cc:</B>
lhoar@shaw.ca<BR><B>Subject:</B> RE: SQL - declare ... Cursor command in
qdesign<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P dir=ltr><SPAN lang=en-gb></SPAN><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>Well</FONT></SPAN><SPAN lang=en-gb></SPAN><SPAN lang=en-gb> <FONT
face="Courier New" color=#0000ff>that</FONT></SPAN><SPAN lang=en-gb></SPAN><SPAN
lang=en-gb><FONT face="Courier New" color=#0000ff> answers my previous
email</FONT></SPAN><SPAN lang=en-gb></SPAN><SPAN lang=en-gb><FONT
face="Courier New" color=#0000ff>; 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 face="Courier New" color=#0000ff>-----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 face="Courier New"
color=#0000ff>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 face="Courier New" color=#0000ff>in the
initialize procedure in order to get the proper values, the
auto</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>retrieval
didn't work. </FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>cheers</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff></FONT></SPAN> </P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>-----Original
Message-----</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>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 face="Courier New" color=#0000ff>Sent: Thu,
November 30, 2006 4:33 PM</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>To: Johnson,
Harold A EDUC:EX; powerh-l@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Subject: RE:
SQL - declare ... Cursor command in qdesign</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>How about
adding something like 'where (productid >= :tnum)' to your</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>cursor and
add syntax to prompt for tnum, either via the access</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>statement, in
the postpath proc, or ammend the path proc...</FONT></SPAN></P><BR>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>-----Original
Message-----</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>From:
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>[<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 face="Courier New" color=#0000ff>Behalf Of
Johnson, Harold A EDUC:EX</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Sent: 30
November 2006 20:15</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>To:
powerh-l@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Subject: RE:
SQL - declare ... Cursor command in qdesign</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>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 face="Courier New" color=#0000ff>properly
using subsitution. Only if we hard code the selection from
the</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>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 face="Courier New" color=#0000ff>web using
cursors?</FONT></SPAN></P><BR>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>Thnx</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff></FONT></SPAN> </P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>-----Original
Message-----</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>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 face="Courier New" color=#0000ff>Sent: Thu,
November 30, 2006 10:13 AM</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>To: Johnson,
Harold A EDUC:EX; powerh-l@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Subject: RE:
SQL - declare ... Cursor command in qdesign</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>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 face="Courier New" color=#0000ff>By specifying
RDB/VMS versus RDB as the relational type, you specify how</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>the database
is accessed and what PowerHouse capabilities are available.</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Using
RDB/VMS, the database is accessed via the native API, while
RDB</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>specifies an
SQL interface using the PowerHouse data access layer.</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>RDB/VMS is
essentially the same interface and feature set as in</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>PowerHouse
7.10. Using RDB allows you to use SQL statements and</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>SQL-related
syntax such as the DECLARE CURSOR and CURSOR statements and</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>the
SQL-related verbs. Since the two interfaces are quite
different,</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>there will
likely be performance differences, however which will be</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>faster is
situation dependant.</FONT></SPAN></P><BR><BR>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>-----Original
Message-----</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>From:
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>[<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 face="Courier New" color=#0000ff>Behalf Of
Johnson, Harold A EDUC:EX</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Sent: 30
November 2006 17:57</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>To:
powerh-l@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Subject: SQL
- declare ... Cursor command in qdesign</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Hi all.
We are operating on Alpha servers with OpenVMS, v8.2, PH</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>v840d1, using
PH Web as an interface. We encountered an error
when</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>attempting to
use the SQL - declare cursor command:</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Ie: sql
in <database> declare <name> cursor for select *
from</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff><table>....</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>*E* The
database 'SFAS_DATABASE' is the wrong type.</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Our database
type is "RDB/VMS", which is the preferred type as I</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>understood. However, when I changed the type back to just
plain old</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>"RDB", the
error went away. </FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>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 face="Courier New"
color=#0000ff>check?</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>Cheers</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>--</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>= = = = = = =
= = = = = = = = = = = = = = = = = = = = = Mailing list:</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>powerh-l@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Subscribe:
&quot;subscribe&quot; in message body to</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>powerh-l-request@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Unsubscribe:
&quot;unsubscribe &lt;password&gt;&quot; in message body
to</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>powerh-l-request@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff><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 face="Courier New" color=#0000ff>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 face="Courier New" color=#0000ff>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 face="Courier New" color=#0000ff>list archive
at Google.</FONT></SPAN></P><BR>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>--</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>= = = = = = =
= = = = = = = = = = = = = = = = = = = = = Mailing list:</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>powerh-l@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Subscribe:
&quot;subscribe&quot; in message body to</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>powerh-l-request@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff>Unsubscribe:
&quot;unsubscribe &lt;password&gt;&quot; in message body
to</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New"
color=#0000ff>powerh-l-request@lists.sowder.com</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-gb><FONT face="Courier New" color=#0000ff><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 face="Courier New" color=#0000ff>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 face="Courier New" color=#0000ff>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 face="Courier New" color=#0000ff>list archive
at Google.</FONT></SPAN></P></BODY></HTML>