Hello!
Have I understood i right when I say that in CR8 a stored procedure(sp) MUST return a resultset? If it is so, is there a way that one can avoid this?
You see I have a report in CR7 that calls a sp that generates some temporary tables, but the sp doesn't return anything. In CR8 I can't get this report function properly.
Does a report in CR8 which uses sp's have to use the 'IN OUT CURSOR' as an parameter or can this be avoided? If it can't be avoided what can I do to prevent this parameter to be visible for the user who want to view this report?
Does anybody understand what I am trying to do here?
In short terms: I would like to write a report in CR8, or preferably use the one I have in CR7, that calls a sp but that sp doesn't return anything.
andreako!
Have I understood i right when I say that in CR8 a stored procedure(sp) MUST return a resultset? If it is so, is there a way that one can avoid this?
You see I have a report in CR7 that calls a sp that generates some temporary tables, but the sp doesn't return anything. In CR8 I can't get this report function properly.
Does a report in CR8 which uses sp's have to use the 'IN OUT CURSOR' as an parameter or can this be avoided? If it can't be avoided what can I do to prevent this parameter to be visible for the user who want to view this report?
Does anybody understand what I am trying to do here?
In short terms: I would like to write a report in CR8, or preferably use the one I have in CR7, that calls a sp but that sp doesn't return anything.
andreako!