asked
When i execute a stored procedure in the application database,the values added are not reflected in the front end.What can be the reason??
I am a Software Tester and i am new to database testing. My application database has a stored procedure for inserting values into a table. I executed that procedure and the values got added into the table. But the same values are not reflected in the front end.What can be the reason? I am able to add values in tables by sql queries though and these values are also reflected in the front end.
Based on the information in the question, there isn't a specific reason. Is there anything else you can tell us that is specific to your environment or test setup that might help identify the problem? Maybe you could try some of the following questions to help determine the problem: What are the stored procedures doing differently than your sql queries? Are you running the stored procedures in the same server and database as the sql queries? are the data reflected instantaneously upon insert, or are the stored procedure inserts never showing up even when you do something in the application that should cause them to appear? when you execute the stored procedures, can you see the newly inserted data with a sql query? Are the stored procedure executions being rolled back? Do the stored procedures have any user or role based logic that causes them to do something different when executed from your testing tool or by a test user?
Hi, probably front end has cached the data - so you need to click some kind of "Refresh" button (front end usually does not know that you have updated table in the database)
16 People are following this question.
