Data Deployment Problem

Aaron Young — Fri, 27 Mar 2009 09:00:56 GMT

Hi,

Just noticed a problem with decimals during data deployment. I have a simple VERSION table defined as follows:-

Field Name Field Type
NAME VarChar(40) - primary key
VALUE Decimal(10,2)

I have created a data deployment package set to overwrite and have noticed that the deployment stored procedure which is created doesn't support decimal places in the VALUE field. The stored procedure definition is:-

CREATE PROCEDURE VERSIONInsertOverwrite @NAME as VarChar(40), @VALUE as Decimal AS BEGIN DELETE FROM VERSION WHERE NAME = @NAME INSERT INTO VERSION (NAME, VALUE) VALUES (@NAME, @VALUE) END

When the procedure is executed as follows, it drops the decimal places:-

exec VERSIONInsertOverwrite @NAME='Database',@VALUE=10.01

The above code stores a value of 10 instead of 10.01

Just to confirm, the VALUE field is definitely defined as 10.2 and can store a value of 10.01 through an update statement.

Aaron

RE: Data Deployment Problem

Trent L. Taylor — Fri, 27 Mar 2009 09:00:56 GMT

I will set this up and see if I can reproduce. Thanks.

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Data Deployment Problem

Data Deployment Problem

RE: Data Deployment Problem