Could you please review that the parameter values are correct give the
expecte type ?? It maybe a problem with the formatting of the integer
value if you are senbding it as an string.
The method i sent was a simplification of the original, trying to keep it as simple as possible. Originally I was using the DBCommandWrapper, which maps the parameter types from system types to ADO provider types.
I quickly wrote the above method to ensure that the mappings weren't the problem, and to check what values the parameters were set with. The "IsPercentage" parameter receives a boolean value, stored as a smallint in the database, the varchars ("Name" & "Code") receive strings, and the "FK_CurrencyID" & "ID" paramaters are both ints.
I'm probably going to kick myself when i know what's wrong, but i can't find it anywhere. I'm not even sure if the return value is the problem, or the value being sent.
