Hi you al!
I'm in the quest to get mobile some procedures, but I found myself into something I can't quite resolve..
Have the following calling procedure.
ASSIGN FRAME {&FRAME-NAME} fFecha fFEcha-2 .
CREATE SERVER hServer.
GET-KEY-VALUE SECTION "CONNECTION" KEY "AppServerSuc" VALUE charID.
lRetOK = hServer:CONNECT (charID) NO-ERROR.
IF NOT lRetOK THEN
DO:
MESSAGE "..."
VIEW-AS ALERT-BOX ERROR.
RETURN.
END.
ELSE
DO:
{procs\inc\wait.i}
RUN dw/GetAperturas.p ON hServer
(fFecha, fFEcha-2, OUTPUT DATASET dsApertura ) NO-ERROR.
END.
hServer:DISCONNECT ().
DELETE OBJECT hServer.
EMPTY TEMP-TABLE scrApertura.
FOR EACH ttApertura:
CREATE scrApertura.
ASSIGN
scrApertura.Sucursal = ttApertura.Sucursal ....
END.
{&OPEN-BROWSERS-IN-QUERY-DEFAULT-FRAME}
Then on appserver I have this called procedure (GetAperturas.p)
{"DW\dwapertura.i"}
DEFINE INPUT PARAMETER pFecha1 AS DATE NO-UNDO.
DEFINE INPUT PARAMETER pFecha2 AS DATE NO-UNDO.
DEFINE OUTPUT PARAMETER DATASET FOR dsApertura.
DEFINE VARIABLE FechaCorriente AS DATE NO-UNDO.
/* *************************** Main Block *************************** */
ASSIGN
FechaCorriente = pFecha1.
DO WHILE FechaCorriente <= pFecha2:
FOR EACH dwh.Sucursal WHERE Sucursal.EnLinea NO-LOCK:
IF .....
FOR EACH Apertura NO-LOCK
WHERE Apertura.Sucursal = Sucursal.Sucursal
AND Apertura.Fecha = FechaCorriente:
CREATE ttApertura.
BUFFER-COPY Apertura TO ttApertura.
END.
END.
ELSE
DO:
CREATE ttApertura.
ASSIGN
.......
END.
END.
ASSIGN
FechaCorriente = FechaCorriente + 1.
END.
My problem came at the point where the procedure has parameters,
I woul like to use that same procedure to expose as rest for using with jsdo and stuff... and remote proc at PAS...
Am I getting it right? or Am I confused about the possibilities on the technology involved? and should have 2 parallel procedures?
Ok!!!
Will do... Thanks!