Devart Forums

Can I and how can I use one TMSStoredProc component with many strored procedures?

I have two different stored procs with different StoredProcNames names and params on the server and I want to use onlny one TMSStoredProc component do execute them interchangeable on the run-time (each of stored procs returns a result set (rows)).
(first, I want get result set from the first stored proc; next, I want use the same component to execute different stored proc and get different result set; and so on from beginning)

Can I do this? How?

What steps I must do and how must I assign or set properties for this component to make him work?


Thanx

B4rT

It's enough to change StoredProcName. But it is not a good solution from the point of view of performance as for describe parameters call to the server is required. It would be correct to use two instances of TMSStoredProc