Re: UPDATE problems with Parameters

Yes, the problem is that this information seems to be omitted by help, at
least it is not emphasized. I found this page which has a tiny statement
about order of oledb parameters
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingstoredprocedureswithcommand.asp

" When using parameters with an OleDbCommand or OdbcCommand, the order of
the parameters added to the Parameters collection must match the order of
the parameters defined in your stored procedure. "

Peter


.

Relevant Pages

  • Stored procedure parameter
    ... should I be able to set the value for a parameter to a stored procedure to ... IDataParameter param = command.CreateParameter; ... Peter ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: sqltransaction
    ... stored procedure may be doing something with the master id.. ... Peter ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using Microsoft Photo Editor with Windows XP Pro / Office 2003
    ... Is there any way to install it on my ... > Appreciate any guidance. ... Prev by Date: ...
    (microsoft.public.office.misc)
  • Re: Why does the stored procedure always return the same value?
    ... I added it in the ADONET newsgroup yesteday before attaching here but ... But do you think a stored procedure will ...
    (microsoft.public.dotnet.languages.vb)
  • RE: String as output from SP in C++
    ... actually had 2 queries in it and the Parameters collection was not cleared ... Thanks Mike - LOL ... string from a stored procedure. ... adParamOutput, 2560, var_phy_email); ...
    (microsoft.public.data.ado)