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

Re: Strange Problem - Urgent Help.



Hello,

        These kind of hard to solve problems, could be easily solved using our SQR
Interactive debugger.     It creates a trace file which is easier to debug
the SQR.

        Thaks.

Gopal
TCS INC
(210) 491 0046

At 04:26 PM 10/27/98 -0800, you wrote:
>Srini,
>In a process definition check "Process Definition Options" -> "SQR
>Parameters",
>you probably need to append there oper. Id and run control so you won't be
>prompted for them.
>
>Ok Boris.
>
>At 09:40 AM 10/27/98 +0530, you wrote:
>>Hello All,
>>     Thankx a lot for the answers . My code in SQR looks like this.
>>
>>!*************************************************
>>BEGIN-PROCEDURE Init-Report
>>  do stdapi-init
>> if $d_prcs_process_instance = ''
>>    !No Prompt
>>  else
>>    do Select-Parameters
>>  end-if
>>END-PROCEDURE Init-Report
>>!************************************************
>>
>>Both my SQR's contain this code . And both are run from Process Scheduler
>>and not thru SQR runtime.
>>I did find the input command in the sqc  PRCSAPI.SQC. But the surprising
>>thing is the INPUT command executes only for one of the SQR's wherein for
>>the other SQR is it fine, it doesn't execute.
>>      The process types for both of them is "SQR Report". This is really
>>strange. Could anyone please help me in this. We are stuck with this
>>problem.
>>
>>Thankx in Advance
>>
>>
>>Srini.
>>
>>---------------------------------------- Message History
>>      ----------------------------------------
>>
>>
>>From: Daniel_Guynes@peoplesoft.com on 10/26/98 05:29 PM GMT
>>
>>Please respond to SQR-USERS@usa.net
>>
>>To:   SQR-USERS@list.iex.net
>>cc:
>>Subject:  Re: Strange Problem - Urgent Help.
>>
>>
>>
>>
>>Look in your PRCSAPI.SQC  I do believe that message derives from there.  It
>>is because of how you have your fetch values set up.  You should have
>>something similar to the following in your Init-Report procedure:
>>
>>  if $prcs_process_instance = ''
>>    !No Prompt           This means youa re running from off-line ... ie.
>>from SQRW.exe or something.
>>  else
>>    do Select-Parameters      This means you are running on line, and this
>>procedure here points to HRRUNCTL1.SQC which selects parameters for you.
>>  end-if
>>
>>Hope it helps
>>
>>Danny
>>
>