Results 1 to 2 of 2

Thread: Decimal Data Type

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Oct 2000
    Location
    Texas
    Posts
    111

    Angry

    Hello everybody.

    I am having a problem passing a variable to a stored procedure. I am calling an MTS object to run the procedure. Everything is working fine, except one SQL field. The field is of type Decimal, length is 9, precision is 10, and scale is 5. If I pass the parameter, which has a value of 1.5, to the ADO command object as type adInteger, it works but is rounded. The variable is a short. I can change it if need be. I tried passing it to the proc as type adDecimal, but I get an error. Does anyone know how I should set up this parameter?

    Thanks.

  2. #2
    Guest
    Hi, this is just a try,

    try vbdouble instead of vbdecimal. I just have a feeling this might work. Sorry if it doesnt...all the best...vijay

Posting Permissions

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



Click Here to Expand Forum to Full Width