SQL - declare ... Cursor command in qdesign
Johnson, Harold A EDUC:EX
Harold.A.Johnson at gov.bc.ca
Mon Dec 4 11:38:13 CST 2006
That appears to be the case, although we were stratching our heads over
this.
cheers
________________________________
From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
Sent: Mon, December 4, 2006 9:24 AM
To: Johnson, Harold A EDUC:EX; powerh-l at lists.sowder.com
Cc: lhoar at shaw.ca
Subject: RE: SQL - declare ... Cursor command in qdesign
Well that answers my previous email; does that mean that you have to
pass in the selection parameters from the previous screen ?
-----Original Message-----
From: Johnson, Harold A EDUC:EX [mailto:Harold.A.Johnson at gov.bc.ca]
Sent: 04 December 2006 17:15
To: Joe Boyle; powerh-l at lists.sowder.com
Cc: lhoar at shaw.ca
Subject: RE: SQL - declare ... Cursor command in qdesign
Thnx for the tips, we now have it working. We had to force a retrieval
in the initialize procedure in order to get the proper values, the auto
retrieval didn't work.
cheers
-----Original Message-----
From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
Sent: Thu, November 30, 2006 4:33 PM
To: Johnson, Harold A EDUC:EX; powerh-l at lists.sowder.com
Subject: RE: SQL - declare ... Cursor command in qdesign
How about adding something like 'where (productid >= :tnum)' to your
cursor and add syntax to prompt for tnum, either via the access
statement, in the postpath proc, or ammend the path proc...
-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On
Behalf Of Johnson, Harold A EDUC:EX
Sent: 30 November 2006 20:15
To: powerh-l at lists.sowder.com
Subject: RE: SQL - declare ... Cursor command in qdesign
Although we now don't get the error, we can't get a drop down to work
properly using subsitution. Only if we hard code the selection from the
table does it work. How do we get a run time selection to work in PH
web using cursors?
Thnx
-----Original Message-----
From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
Sent: Thu, November 30, 2006 10:13 AM
To: Johnson, Harold A EDUC:EX; powerh-l at lists.sowder.com
Subject: RE: SQL - declare ... Cursor command in qdesign
I have the note below but can't recall where it came from originally,
By specifying RDB/VMS versus RDB as the relational type, you specify how
the database is accessed and what PowerHouse capabilities are available.
Using RDB/VMS, the database is accessed via the native API, while RDB
specifies an SQL interface using the PowerHouse data access layer.
RDB/VMS is essentially the same interface and feature set as in
PowerHouse 7.10. Using RDB allows you to use SQL statements and
SQL-related syntax such as the DECLARE CURSOR and CURSOR statements and
the SQL-related verbs. Since the two interfaces are quite different,
there will likely be performance differences, however which will be
faster is situation dependant.
-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On
Behalf Of Johnson, Harold A EDUC:EX
Sent: 30 November 2006 17:57
To: powerh-l at lists.sowder.com
Subject: SQL - declare ... Cursor command in qdesign
Hi all. We are operating on Alpha servers with OpenVMS, v8.2, PH
v840d1, using PH Web as an interface. We encountered an error when
attempting to use the SQL - declare cursor command:
Ie: sql in <database> declare <name> cursor for select * from
<table>....
*E* The database 'SFAS_DATABASE' is the wrong type.
Our database type is "RDB/VMS", which is the preferred type as I
understood. However, when I changed the type back to just plain old
"RDB", the error went away.
Is this on purpose, or is the "RDB/VMS" type just missing from the error
check?
Cheers
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20061204/5924908b/attachment.htm
More information about the powerh-l
mailing list