Hi.
I'm trying to create a dynamic editable report (form) with a dynamic set of fields. To do this, I need to have a dynamic set of dbr.editable statements that match those fields. I have the procedure that builds the field listing and it displays fine. I also have the procedure that generates the set of dbr.editable lines which work find if static. But I'm tring to make a call to that procedure to include them in the 'main' report.
Just using CALL myEditableInstructions(myvariables); doesn't work and I also tried wrapping it in dbr.record begin-end statements like:
SELECT 'dbr.record', 'begin';
CALL myEditableInstructions(myvariables);
SELECT 'dbr.record', 'end';
What I can't figure out is how to 'play back' this resultset. I've tried having nothing after and having a dummy select like:
SELECT "" AS EditableInstructionsResult;
But so far it hasn't worked to get the actual editable statements recognised and working.
Do you have any suggestions?
FYI: so far with is without tempates but it will soon be used in a template.