March 27, 2002 at 12:06 pm
Use the Refresh method of the Command object at DESIGN time, to populate your parameters collection, and save yourself one giant headache.
March 27, 2002 at 12:21 pm
I already thought of using refresh but I wanted the best performance I could get.
Thanks for the input 😉
A.S.
MCSE, ASE, DBA
Webmaster
Applications Developer
March 28, 2002 at 5:53 am
If you use refresh at RUN TIME it will affect performance because it will cause you to make another round-trip to the database. This is not what I meant. If you use the refresh method at DESIGN TIME to write out the parameters collection code, then put the code into your project you will have no performance loss and you will get all your datatypes etc filled in for you.
March 28, 2002 at 7:13 am
That's why I recommend using the stored proc add-in that was mentioned in the link I posted to my article. It generates all the param code for you. Definitely don't want to use refresh for live stuff.
Andy
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply