PowerHouse 4GL question: database locking

[Peter Bateman]

Hi Murray:
 
    You can use other DBMODEs in QUIZ see SET DBMODE option.
    However, most QUIZ programmers use a date or a status to exclude unwanted
    data from getting into the report.
    access a_dataset link a_item to a_item of b_dataset
    select b_dataset if order_status = 'Completed' and order_date > date (days ( sysdate ) - 30 )
 
    
Regards,
Peter Bateman
 
    > From: wmurray at surewest.net> To: HP3000-L at RAVEN.UTC.EDU; powerh-l at lists.sowder.com> Subject: PowerHouse 4GL question: database locking> Date: Thu, 4 Oct 2007 21:14:55 -0700> > Greetings,> > I'm in the process of learning PowerHouse 4GL, and I'm trying to> understand how it manages database locking.> > The environment is PowerHouse 8.39.C1 on MPE/iX 7.5, TurboIMAGE access> modes 1 and 5.> > As I understand it, the default for QTP, whether in mode 1 or mode 5, is> to lock the whole database for the duration of the run. The SET LOCK> statement can be used to change the locking level, or even to eliminate> locking completely (assuming the database is not being modified).> Unless locking is suppressed, interactive QTP attempts a conditional> lock every few seconds until it is satisfied or the user interrupts it;> batch mode QTP does an unconditional lock. This is all documented in> the QTP Reference.> > Please correct me if I don't have that completely right.> > The question is about QUIZ. As I understand it, the default access mode> is 5, but QUIZ doesn't do database locking. Can this be right? Is> there no way to make QUIZ lock the database while accessing it, as a> protection against other users modifying the same data that QUIZ is> accessing?> > Thanks for bearing with my beginner's questions.> > Walter > > Walter J. Murray> > > > > -- > = = = = = = = = = = = = = = = = = = = = = = = = = = = => 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.
_________________________________________________________________
Get next generation emoticons
http://www.freemessengeremoticons.ca/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20071005/1114c52d/attachment.html