Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003
    Location
    UK
    Posts
    10

    Unhappy Unanswered: Stored Proc , Precision & ADO

    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)
    With prm2
    .Precision = 4
    .NumericScale = 2
    End With

    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.

    Cheers
    Last edited by jayman; 12-15-03 at 09:15.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •