Subject Re: [IBO] Update SQL & Parameters
Author Geoff Worboys
> I'm using a selectable procedure for my SQL, which uses the same
> parameter I'm trying to feed to the EditSQL, if that is relevant.

I think I understand. I generally find it useful to setup my select
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