Subject | Re: [IBO] Update SQL & Parameters |
---|---|
Author | Geoff Worboys |
Post date | 2002-02-01T22:21:25Z |
> I'm using a selectable procedure for my SQL, which uses the sameI think I understand. I generally find it useful to setup my select
> parameter I'm trying to feed to the EditSQL, if that is relevant.
procedures to "reflect" the inputs - which then allow me to use those
values in relationships against that procedure.
eg.
CREATE PROCEDURE SOME_SELECT_PROC( INPUT_VAL INTEGER )
RETURNS ( VAL INTEGER, SOME_OTHER_STUFF VARCHAR(20) )
AS
BEGIN
VAL = INPUT_VAL; // reflect the input value
SOME_OTHER_STUFF = 'whatever';
SUSPEND;
END^
With such a setup you now have a "field" returning from the procedure
which is the same value as the input parameter which can then be used
where needed (such as EditSQL).
hth
--
Geoff Worboys
Telesis Computing