<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
<BR>Hi Murray:<BR>
<BR>
You can use other DBMODEs in QUIZ see SET DBMODE option.<BR>
However, most QUIZ programmers use a date or a status to exclude unwanted<BR>
data from getting into the report.<BR>
access a_dataset link a_item to a_item of b_dataset<BR>
select b_dataset if order_status = 'Completed' and order_date > date (days ( sysdate ) - 30 )<BR>
<BR>
<BR>
Regards,<BR>
Peter Bateman<BR>
<BR>
<BR>> From: wmurray@surewest.net<BR>> To: HP3000-L@RAVEN.UTC.EDU; powerh-l@lists.sowder.com<BR>> Subject: PowerHouse 4GL question: database locking<BR>> Date: Thu, 4 Oct 2007 21:14:55 -0700<BR>> <BR>> Greetings,<BR>> <BR>> I'm in the process of learning PowerHouse 4GL, and I'm trying to<BR>> understand how it manages database locking.<BR>> <BR>> The environment is PowerHouse 8.39.C1 on MPE/iX 7.5, TurboIMAGE access<BR>> modes 1 and 5.<BR>> <BR>> As I understand it, the default for QTP, whether in mode 1 or mode 5, is<BR>> to lock the whole database for the duration of the run. The SET LOCK<BR>> statement can be used to change the locking level, or even to eliminate<BR>> locking completely (assuming the database is not being modified).<BR>> Unless locking is suppressed, interactive QTP attempts a conditional<BR>> lock every few seconds until it is satisfied or the user interrupts it;<BR>> batch mode QTP does an unconditional lock. This is all documented in<BR>> the QTP Reference.<BR>> <BR>> Please correct me if I don't have that completely right.<BR>> <BR>> The question is about QUIZ. As I understand it, the default access mode<BR>> is 5, but QUIZ doesn't do database locking. Can this be right? Is<BR>> there no way to make QUIZ lock the database while accessing it, as a<BR>> protection against other users modifying the same data that QUIZ is<BR>> accessing?<BR>> <BR>> Thanks for bearing with my beginner's questions.<BR>> <BR>> Walter <BR>> <BR>> Walter J. Murray<BR>> <BR>> <BR>> <BR>> <BR>> -- <BR>> = = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>> Mailing list: powerh-l@lists.sowder.com<BR>> Subscribe: &quot;subscribe&quot; in message body to powerh-l-request@lists.sowder.com<BR>> Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to powerh-l-request@lists.sowder.com<BR>> http://lists.sowder.com/mailman/listinfo/powerh-l<BR>> This list is closed, thus to post to the list you must be a subscriber.<BR>> Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<BR><BR><br /><hr />Be seen when you can't be heard! <a href='http://www.freemessengeremoticons.ca/' target='_new'>Discover how today!</a></body>
</html>