Can it work using Quick ? Works with quiz.

[Robert Edis]

You can probably also get the result you want using
the same file/table as both primary (for the credit
limit) and detail alias (for the sum of the credit
used) by user.

If not detail then a designer file and in a post find
procedure calculate the sum of credit used and put in
a temp variable.  Compare this with the credit limit
in the primary file.  Make sure the primary file is
read as distinct values (userid + creditlimit) though.

Blue

--- Yvonne Erkes <Yvonne@Kinetix.co.nz> wrote:

> Hi all  
> 
> Well...our quick version does read subfiles !! 
> *yippee*  *phew*
> 
> This really speeds up a solution.
> I can now create a qtp process to create/update the
> values in a subfile
> prior to having the quick screen being run.
> 
> Thanks for the help everyone :)))))
> 
> 
> -----Original Message-----
> From: powerh-l-admin@lists.sowder.com
> [mailto:powerh-l-admin@lists.sowder.com] On Behalf
> Of Guy Werry
> Sent: Tuesday, November 16, 2004 9:08 AM
> To: powerh-l@lists.sowder.com
> Subject: RE: Can it work using Quick ? Works with
> quiz.
> 
> 
> David,
> 
> If your version of Quick is recent enough then it
> can read the subfiles.
> If you can read the subfiles then you can display
> the required results
> on the screen.
> 
> Another option would be to simply have the Quick
> screen call the Quiz
> report.  We do a fair bit of this at my shop (Ux
> 10.2, PH 7.33.D3) where
> we create the report to a disc file that is defined
> as an operating
> system variable (this requires executing the Quiz
> from source code),
> then using the system utility "more" to read the
> report file to the
> screen.  Then we provide the user the option to
> print the file after
> viewing it.  We normally remove the printfile on the
> screen exit.
> 
> Please put you OS/version info in when using the
> list.
> 
> Guy L. Werry
> Senior Systems Analyst
> Hudson Bay Mining & Smelting Co., Limited. 
> 
> -----Original Message-----
> From: Yvonne Erkes [mailto:Yvonne@Kinetix.co.nz]
> Sent: Monday, November 15, 2004 1:53 PM
> To: powerh-l@lists.sowder.com
> Subject: Can it work using Quick ? Works with quiz.
> 
> 
> 
> > Hi all.
> >
> > Would you be able to enlighten me on how to solve
> a problem I have 
> > with quick screens vs quiz reporting?
> >
> > I've been asked to create a quick screen which
> will display all 
> > customers that have gone over their overall credit
> limit. (Customer 
> > can have more than one credit card)
> >
> > The file records store credit limit & account
> balance...but not the 
> > difference.
> >
> > Is there a way of displaying only the customers
> with total account 
> > difference being greater than their total account
> credit limit ?
> >
> > I'm able to get results using quiz subfiles, but
> am having problems 
> > figuring out how to get results using quick.
> >
> >  
> >
> >  
> >
> >  
> >
> >  
> >
> 
> 
> -- 
> David R. Sowder
> Supervisor of Language Acquisition Center
> Department of Modern Languages
> University of Texas at Arlington
>     Work: 817-272-5148  davids@uta.edu   
> http://langlab.uta.edu/
> Personal:               david@sowder.com 
> http://david.sowder.com/
> 
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = =
> = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message
> body to
> powerh-l-request@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.
> = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = Mailing list:
> powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message
> body to
> powerh-l-request@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.
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = =
> = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message
> body to powerh-l-request@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.
>