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
One TMSStoredProc component used with many strored procedures - HOW?
Re: One TMSStoredProc component used with many strored procedures - HOW?
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