The precision is invalid

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: shank (shank_at_tampabay.rr.com)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 14:47:16 -0400

Using Dreamweaver, I'm trying to update a table using a stored procedure.
I'm getting the following error. The line# reference is on the last line:
rsUpdate.Execute(). That doesn't help much, but I'm sure the problem must be
with the number fields: Royalty (money) or Ownership (float). How do I
change the precision to match the table? In this line: "@Royalty", 6,
1,8,varRoyalty, what does 6,1,8 represent. Where can I find a
crossreference? I believe 6 is datatype money, 8 is size in bytes. What is
1...?
thanks

Microsoft OLE DB Provider for SQL Server error '80004005'
The precision is invalid.

<%
set rsUpdate = Server.CreateObject("ADODB.Command")
rsUpdate.ActiveConnection = ConnString
rsUpdate.CommandText = "stp_Publisher_Update"
rsUpdate.CommandType = 4
rsUpdate.CommandTimeout = 0
rsUpdate.Prepared = true
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Title", 200,
1,255,varTitle)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Artist", 200,
1,255,varArtist)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Gender", 200,
1,1,varGender)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Genre", 200,
1,50,varGenre)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@VocalRange", 200,
1,20,varVocalRange)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@GroupLevel", 200,
1,20,varGroupLevel)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@YearReleased", 200,
1,4,varYearReleased)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Agent", 200,
1,50,varAgent)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Publisher", 200,
1,50,varPublisher)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Royalty", 6,
1,8,varRoyalty)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Owner", 200,
1,50,varOwner)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Ownership", 131,
1,9,varOwnership)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Writers", 200,
1,255,varWriters)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@Comments", 200,
1,8000,varComments)
rsUpdate.Parameters.Append rsUpdate.CreateParameter("@ID", 131, 1,9,varID)
rsUpdate.Execute()
%>

Relevant Pages

  • Re: Alternative voltage reference?
    ... using an opamp voltage follower. ... What's the voltage reference for? ... Again, no precision. ... the pot, which means you can at least trap your 0.5V in there with a ...
    (sci.electronics.basics)
  • Re: 1% zener diodes?
    ... Once upon a time zeners were king as reference diodes. ... your needed a precision resistor biased from the reference ... and note that the temperature stability is specified at 7.5mA ... In them days I preferred the uA723 when I needed precision. ...
    (sci.electronics.design)
  • Re: 1% zener diodes?
    ... Once upon a time zeners were king as reference diodes. ... Only at 7.5mA - to get all the precision that you paid for with the! ... I usually do have a crowbar but I have never seen that phenomenon, ... This is very frustrating for a teenager who isn't a chip expert yet. ...
    (sci.electronics.design)
  • Re: 1% zener diodes?
    ... precision zeners at either 1 or 2% increments, ... Once upon a time zeners were king as reference diodes. ... Only at 7.5mA - to get all the precision that you paid for with the! ... and note that the temperature stability is specified at 7.5mA ...
    (sci.electronics.design)
  • Re: Rounding error for a value of 1.09
    ... > perform manipulations on it to get the value I need to reference ... I have no issues with any precision or rounding on ... > confirmed that this happens in a new spreadsheet as well. ... > Enter "1.09" in cell A1 ...
    (microsoft.public.excel.misc)