Here is sample code to support my last post.
The cmd.Parameters.Refresh method (supported on some rdbms) will allow you to see how the database/ado would create the parameters. This is inefficient code, but it works!
I used the locals windows to assist me in writing my code.
Set cmd = New...
I had this problem with SQLServer.
What I did was use the refresh method of the parameters collection to be able to see how MS wanted the parameters filled out. I then wrote the cmd.parameters.append cmd.createparameter code with the appropriate settings.
This was able to resolve my problem.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.