I'm trying to get a decimal calculation from SQL using VBA and ADO.
I've got an output parameter defined as :
.CreateParameter("@Result", adDecimal, adParamOutput, 4)
.Precision = 4
.NumericScale = 2
In the SP the output parameter is defined as:
@Result NUMERIC (4,2) OUTPUT
I was originally getting 'Precision Is invalid' error but have now got rid of those. However I'm 'Invalid use of null' errors now, which is strange because when I execute the SP in Query analyzer it works fine. Any thought would be welcome.