>>
>>Here is one thing that seems to be strange to me. As I mentioned to William, if I comment out the line that set the data type (SqlDbType) and set the value as following:
>>
>>
>>sql.Parameters[0].value = "6.61";
>>
>>
>>everything works. I don't understand how it works since the number is in quotes. But the value that is passed to the stored procedure is numeric. But it works so I should not complain <g>.
>
>:-)
>It works because SQL Server is smart enough to do implicit conversion of the values.
>You always can use SQL Profiler t see what your application send to SQL Server.
>This is the best tool to test your queries.
Thank you for the explanation. I am going to start learning to use the SQL Profiler.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham