Subject | TIB_StoredProc management question |
---|---|
Author | Joe Martinez |
Post date | 2003-05-10T06:33:42Z |
If my app has several stored procedures that I plan to call in my code, how
would I handle creating/handling TIB_StoredProc objects? The options that
I see are as follows:
1) Drop a TIB_StoredProc on the form for each stored procedure in my
database. Access the appropriate object depending on which SP I want to call.
2) Just have one generic TIB_StoredProc on my form. When I want to call an
SP, just change the StoredProcName property to refernce the SP I want to
call. Use AutoDefineParams to keep the paramater list correct.
3) Create TIB_StoredProc objects dynamically at run time in my code, set
the necessary properties, and execute.
Are all 3 viable options? Is any of them better or more efficient?
Thanks,
Joe
would I handle creating/handling TIB_StoredProc objects? The options that
I see are as follows:
1) Drop a TIB_StoredProc on the form for each stored procedure in my
database. Access the appropriate object depending on which SP I want to call.
2) Just have one generic TIB_StoredProc on my form. When I want to call an
SP, just change the StoredProcName property to refernce the SP I want to
call. Use AutoDefineParams to keep the paramater list correct.
3) Create TIB_StoredProc objects dynamically at run time in my code, set
the necessary properties, and execute.
Are all 3 viable options? Is any of them better or more efficient?
Thanks,
Joe