SQL Stored procedures

[Ali_Eldergill_(Guest)]

I need to select certain records, according to filters entered at run time, but having selected them, I then need to update the records as printed. The obvious thing seems to call a stored procedure from the report, so that I can do the update. Problem is - how do I pass the filter information through to the stored procedure - if I can^t do that I^m going to end up updating every record! Is there any other way such as using RI_REPLACE that this can be achieved?____Any help will be greatly appreciated!

[kfleming]

If your stored procedure had a required parameter you could indeed enclose that parameter in double brackets and use RI_REPLACE to feed it a value at runtime. But I do not know enough about stored procedures to know if this would really work as you wish but the input would have to be a parameter to the stored procedure.____Kathleen__R&R Support