SQL - declare ... Cursor command in qdesign

[Johnson, Harold A EDUC:EX]

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: &quot;subscribe&quot; in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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.