Database for testing - problems with updates

4 posts, 0 answers
  1. Matthias
    Matthias avatar
    16 posts
    Member since:
    Jan 2017

    Posted 19 Jul Link to this post

    Hello

    we try to use a database for a test. We write into a table the date of two days ago and of three days ago. These dates are our variables in the test.

     

    The problem: The dates are not updated (example: variables two days ago 14/7 and 15/7, variables of today 14/7 and 15/7, but it should be 16/7 and 17/7)

     

    Our stored procedure:

    USE [DATABASE]
    GO
    /****** Object:  StoredProcedure [dbo].[Listsearch_Report_Dates_Procedure]    Script Date: 19.07.2017 12:25:15 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO

    ALTER PROCEDURE [dbo].[Listsearch_Report_Dates_Procedure]
    AS
    BEGIN

    Update dbo.Listsearch_Report_Dates

    Set Vorgestern = CONVERT(VARCHAR(6), getdate()-2, 4), 
    Vorvorgestern = CONVERT(VARCHAR(6), getdate()-3, 4) 

    select * from Listsearch_Report_Dates
    END

     

     

  2. Elena Tsvetkova
    Admin
    Elena Tsvetkova avatar
    608 posts

    Posted 24 Jul Link to this post

    Hi Matthias,

    Thanks for the shared details. 

    Please let me know if you have clicked on the Update button (please see screenshot) and what the result was. Also did you run the test? Was it taking the correct values in runtime? 

    Please also let me know what type is the database you have decided to use in case none of the above works as expected. 

    Thanks in advance! 

    Regards,
    Elena Tsvetkova
    Progress Telerik
     
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
  3. Matthias
    Matthias avatar
    16 posts
    Member since:
    Jan 2017

    Posted 24 Jul Link to this post

    Now we use another database and it works. It is quite difficult to explain, because our settings are the same and we didn't change something in our configuration.
  4. Elena Tsvetkova
    Admin
    Elena Tsvetkova avatar
    608 posts

    Posted 27 Jul Link to this post

    Hi Matthias,

    Thanks for the feedback. I am glad to know the issue was resolved somehow although it is not quite clear. Though I suspect it might something related to the initial database if it was corrupted somehow. 

    Anyways, I hope you will not face that inconsistent behavior again! 

    Regards,
    Elena Tsvetkova
    Progress Telerik
     
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
Back to Top