locked
A bug? whern reporting hours, decimal converted to int RRS feed

  • Question

  • User641442493 posted

    When i try to report 3,2 H i get 3 Hours  If i try to report 0,5 H i Get 1 Hour.

     

    Ive looked everywhere but it is a decimal value in aspnet_starterkits_timeentry so why cant i store decimalvalues?

    Saturday, January 6, 2007 2:15 PM

All replies

  • User641442493 posted

    i found the solutoin my self :-).

     

    Just put (18,2) after Hours(DECIMAL) in the procedure.

     

     

    Monday, January 8, 2007 4:40 AM
  • User-1790118103 posted
    Where is that procedure? I changed it database schema, but that didn't help.
    Monday, April 23, 2007 11:53 AM
  • User555306248 posted

    You will find it in DB

    Goto Server Explorer - > Data Connections - > TimeTracker.mfd - > Stored Procedure

    Monday, April 23, 2007 11:30 PM
  • User-1790118103 posted

    Ah, found it, in dbo.aspnet_starterkits_CreateNewTimeEntry and dbo.aspnet_starterkits_UpdateTimeEntry I changed

     

    ALTER           PROCEDURE aspnet_starterkits_CreateNewTimeEntry
     @CategoryId            INT,
     @TimeEntryCreatorUserName  NVARCHAR(256),
     @TimeEntryDescription      NVARCHAR(1000),
     @TimeEntryEstimateDuration DECIMAL,
     @TimeEntryEnteredDate        DATETIME,
     @TimeEntryUserName         NVARCHAR(256)
    AS 

     to be

    ALTER           PROCEDURE aspnet_starterkits_CreateNewTimeEntry
     @CategoryId            INT,
     @TimeEntryCreatorUserName  NVARCHAR(256),
     @TimeEntryDescription      NVARCHAR(1000),
     @TimeEntryEstimateDuration DECIMAL(18,2),
     @TimeEntryEnteredDate        DATETIME,
     @TimeEntryUserName         NVARCHAR(256)
    AS

    Tuesday, April 24, 2007 11:07 AM
  • User555306248 posted
    Good [:)]
    Tuesday, April 24, 2007 11:36 PM
  • User-490129417 posted

     

    Thanks !

    You saved my day, and month and more

    M

    Saturday, September 22, 2007 1:20 AM
  • User-490129417 posted

    So putting 18,2 in stored procdure solved the problem to half, when inserting a duration of 1,5 its converted to 2.0 and thats no good.

     So i change 18,2 ti 14,1 in table  aspnet_starterkits_TimeEntry(column TimeEntryDuration) and change the stored procedures aspnet_starterkits_UpdateTimeEntry and aspnet_starterkits_CreateNewTimeEntry

    Now it works.

    Stored procedures can be find here: in the database select progammability, stored procedures

    Saturday, September 22, 2007 2:15 AM
  • User555306248 posted

    Change in dbo.aspnet_starterkits_CreateNewTimeEntry and dbo.aspnet_starterkits_UpdateTimeEntry as

    @TimeEntryEstimateDuration DECIMAL(14,1)

    Sunday, October 14, 2007 11:41 PM