datatype, command and stored procedures -
09-01-2004
, 10:51 AM
I'm trying to use an UPDATE stored procedure call by Command and I'm getting:
Microsoft OLE DB Provider for SQL Server error '80004005' The precision is
invalid.
This must be related to the number field(s), but I don't see where I can
change the precision.
Also, where can I find a cross reference to show what these numbers represent?
200,1,255
thanks
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@Title",
200,1,255,rsPubUpdate__Title)
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@Artist",
200,1,255,rsPubUpdate__Artist)
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@Genre",
200,1,50,rsPubUpdate__Genre)
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@GroupLevel",200,
1,50,rsPubUpdate__GroupLevel)
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@Writers",
200,1,255,rsPubUpdate__Writers)
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@Publisher",
200,1,50,rsPubUpdate__Publisher)
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@Royalty",
6,1,8,rsPubUpdate__Royalty)
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@Ownership",
131,1,9,rsPubUpdate__Ownership)
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@Comments",
200,1,8000,rsPubUpdate__Comments)
rsPubUpdate.Parameters.Append rsPubUpdate.CreateParameter("@ID",
131,1,9,rsPubUpdate__ID)
CREATE TABLE [bls2000].[Publishers] (
[Title] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Artist] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Genre] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[GroupLevel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Writers] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Publisher] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Royalty] [money] NULL ,
[Ownership] [numeric](18, 1) NULL ,
[Comments] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ID] [numeric](10, 0) IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO |