Re: Strange Problem - Urgent Help.

[Srinivasan S <srinivasan.seetharaman@DB.COM>]

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