[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Running Sqr and using sqr parameters in process definition

You will need to get the value from your run control record.  Here's a code
snippet...

Begin-Procedure Get-Values
Begin-Select
OPRID        &oprid
RUN_CNTL_ID  &runcntl
FROM_CLAUSE  &projnamein
   move &projnamein to $projnamein
FROM PS_RUN_CNTL_HR
WHERE OPRID = $prcs_oprid
   AND RUN_CNTL_ID = $prcs_run_cntl_id
End-Select
End-Procedure ! Get-Values

John


At 11:39 AM 10/6/99 -0400, you wrote:
>I can run an a sqr in the process sceduler no problems.  When I set up the
>process
>defintion I
>see a sqr parameter option there. The documentation says you can set up a
>param for
>any field in
>your current panel  group.
>I have a record in the panel group called pay_cntrl  and a field called
>asofdate.
>So in the sqr parameter i did this
>append   :pay_cntrl..asofdate
>
>How do I use this in my sqr ?

----------------------------------------------
Hayes Systems Solutions, Inc.  Canoga Park, CA
mailto:owner@hss-usa.com
http://www.hss-usa.com
----------------------------------------------