Parameters.Refresh

  • This is remarkably simple to ask, but I'm not too sure I know the answer. I know there is a hit with calling ADO Parameters.Refresh

    Am I correct in saying that the Refresh is done only once when the .Refresh method is called? or is the refresh done on every Execute of the command object?

    This is of relevance if I loop .Execute?

    TIA,

    Paul

  • When you call the Parameters collection without calling refersh first ADO automatically does it then, or when you explicitly call Refresh. It never occurrs on Execute.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Thx, I was a bit concerned at performance hit, but in the context I use it in, I don't need to worry in that case.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply