473,804 Members | 1,971 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Duplication of record in database

We have one web application developed in .Net framework 1.1. This site is
live on production server since one year and used across world by many users.

But only one of the users is facing following problem:

Whenever the user submits an “Approval Process” form, there are 3 times
entries of same record with 2 – 5 seconds time difference.

This problem was faced by user in May and now again in last week. So, even
this user does not get this problem always. Nor any other user has reported
same problem.

We maintain an exception log file. There are no exceptions neither written
in this log file nor shown on page. We are not able to replicate this issue.
We even asked user whether she does multiple clicks on submit button or has
multiple sessions opened. But the user denies doing anything of this.

Can anyone help me in this problem? What can be cause for this issue?
Nov 29 '07 #1
7 1754
prevent multiple posting this way

Page_Load or Init
---------------------------------------------------------------------
if not ispostback
session(random_ stringornumber) = 0
else
if session(random_ stringornumber) = 1 then
response.end
end
end
---------------------------------------------------------------------
OnSubmitClick
-----------------------------------------------------
GetReadyToEnter Record;
session(random_ stringornumber) = 1
Finish;

----------------------------------------------------

On Nov 29, 3:13 pm, Kavita <Kav...@discuss ions.microsoft. comwrote:
We have one web application developed in .Net framework 1.1. This site is
live on production server since one year and used across world by many users.

But only one of the users is facing following problem:

Whenever the user submits an "Approval Process" form, there are 3 times
entries of same record with 2 - 5 seconds time difference.

This problem was faced by user in May and now again in last week. So, even
this user does not get this problem always. Nor any other user has reported
same problem.

We maintain an exception log file. There are no exceptions neither written
in this log file nor shown on page. We are not able to replicate this issue.
We even asked user whether she does multiple clicks on submit button or has
multiple sessions opened. But the user denies doing anything of this.

Can anyone help me in this problem? What can be cause for this issue?
Nov 29 '07 #2
Hi Nick,

I know with code I can prevent multiple clicks to avoid this. But the
problem is user says that without doing multiple clicks this problem is
occuring. So we are not able to find out the cause.

"Nick Chan" wrote:
prevent multiple posting this way

Page_Load or Init
---------------------------------------------------------------------
if not ispostback
session(random_ stringornumber) = 0
else
if session(random_ stringornumber) = 1 then
response.end
end
end
---------------------------------------------------------------------
OnSubmitClick
-----------------------------------------------------
GetReadyToEnter Record;
session(random_ stringornumber) = 1
Finish;

----------------------------------------------------

On Nov 29, 3:13 pm, Kavita <Kav...@discuss ions.microsoft. comwrote:
We have one web application developed in .Net framework 1.1. This site is
live on production server since one year and used across world by many users.

But only one of the users is facing following problem:

Whenever the user submits an "Approval Process" form, there are 3 times
entries of same record with 2 - 5 seconds time difference.

This problem was faced by user in May and now again in last week. So, even
this user does not get this problem always. Nor any other user has reported
same problem.

We maintain an exception log file. There are no exceptions neither written
in this log file nor shown on page. We are not able to replicate this issue.
We even asked user whether she does multiple clicks on submit button or has
multiple sessions opened. But the user denies doing anything of this.

Can anyone help me in this problem? What can be cause for this issue?

Nov 29 '07 #3
if u know the code then it doesnt work !

On Nov 29, 3:13 pm, Kavita <Kav...@discuss ions.microsoft. comwrote:
We have one web application developed in .Net framework 1.1. This site is
live on production server since one year and used across world by many users.

But only one of the users is facing following problem:

Whenever the user submits an "Approval Process" form, there are 3 times
entries of same record with 2 - 5 seconds time difference.

This problem was faced by user in May and now again in last week. So, even
this user does not get this problem always. Nor any other user has reported
same problem.

We maintain an exception log file. There are no exceptions neither written
in this log file nor shown on page. We are not able to replicate this issue.
We even asked user whether she does multiple clicks on submit button or has
multiple sessions opened. But the user denies doing anything of this.

Can anyone help me in this problem? What can be cause for this issue?
Nov 29 '07 #4
Hi Nick,

Actually we just want to find out how this can happen if multiple clicks is
not the cause for it. User denies doing multiple click or multiple sessions
open.

User also does not face this always. Sometimes this happen. Even she is not
able to replicate it.

"Nick Chan" wrote:
if u know the code then it doesnt work !

On Nov 29, 3:13 pm, Kavita <Kav...@discuss ions.microsoft. comwrote:
We have one web application developed in .Net framework 1.1. This site is
live on production server since one year and used across world by many users.

But only one of the users is facing following problem:

Whenever the user submits an "Approval Process" form, there are 3 times
entries of same record with 2 - 5 seconds time difference.

This problem was faced by user in May and now again in last week. So, even
this user does not get this problem always. Nor any other user has reported
same problem.

We maintain an exception log file. There are no exceptions neither written
in this log file nor shown on page. We are not able to replicate this issue.
We even asked user whether she does multiple clicks on submit button or has
multiple sessions opened. But the user denies doing anything of this.

Can anyone help me in this problem? What can be cause for this issue?

Nov 29 '07 #5
What's most important is simply to have quality code in place that prevents
it from ever happening, regardless of the cause. It might even be your own
code that is inadvertently causing the condition.

--Peter
"Inside every large program, there is a small program trying to get out."
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com

"Kavita" wrote:
Hi Nick,

Actually we just want to find out how this can happen if multiple clicks is
not the cause for it. User denies doing multiple click or multiple sessions
open.

User also does not face this always. Sometimes this happen. Even she is not
able to replicate it.

"Nick Chan" wrote:
if u know the code then it doesnt work !

On Nov 29, 3:13 pm, Kavita <Kav...@discuss ions.microsoft. comwrote:
We have one web application developed in .Net framework 1.1. This site is
live on production server since one year and used across world by many users.
>
But only one of the users is facing following problem:
>
Whenever the user submits an "Approval Process" form, there are 3 times
entries of same record with 2 - 5 seconds time difference.
>
This problem was faced by user in May and now again in last week. So, even
this user does not get this problem always. Nor any other user has reported
same problem.
>
We maintain an exception log file. There are no exceptions neither written
in this log file nor shown on page. We are not able to replicate this issue.
We even asked user whether she does multiple clicks on submit button or has
multiple sessions opened. But the user denies doing anything of this.
>
Can anyone help me in this problem? What can be cause for this issue?
Nov 29 '07 #6
Users say lots of things, usually starting with "I didn't do anything and my
computer just ........"

Implement code to prevent duplicate postbacks (via refresh button and/or
multiple clicks on submit button) and I bet $1 that the problem mysteriously
vanishes.

Scott
"Kavita" <Ka****@discuss ions.microsoft. comwrote in message
news:C7******** *************** ***********@mic rosoft.com...
Hi Nick,

I know with code I can prevent multiple clicks to avoid this. But the
problem is user says that without doing multiple clicks this problem is
occuring. So we are not able to find out the cause.

"Nick Chan" wrote:
>prevent multiple posting this way

Page_Load or Init
---------------------------------------------------------------------
if not ispostback
session(random_ stringornumber) = 0
else
if session(random_ stringornumber) = 1 then
response.end
end
end
---------------------------------------------------------------------
OnSubmitClic k
-----------------------------------------------------
GetReadyToEnte rRecord;
session(random _stringornumber ) = 1
Finish;

----------------------------------------------------
Nov 29 '07 #7
Perhaps this user is double-clicking something instead of single-clicking
it.
-----Original Message-----
From: Kavita [mailto:Ka****@d iscussions.micr osoft.com]
Posted At: Thursday, 29 November 2007 9:55 PM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Duplication of record in database
Subject: Re: Duplication of record in database

Hi Nick,

Actually we just want to find out how this can happen if multiple
clicks is
not the cause for it. User denies doing multiple click or multiple
sessions
open.

User also does not face this always. Sometimes this happen. Even she is
not
able to replicate it.

"Nick Chan" wrote:
if u know the code then it doesnt work !

On Nov 29, 3:13 pm, Kavita <Kav...@discuss ions.microsoft. comwrote:
We have one web application developed in .Net framework 1.1. This
site is
live on production server since one year and used across world by
many users.
>
But only one of the users is facing following problem:
>
Whenever the user submits an "Approval Process" form, there are 3
times
entries of same record with 2 - 5 seconds time difference.
>
This problem was faced by user in May and now again in last week.
So, even
this user does not get this problem always. Nor any other user has
reported
same problem.
>
We maintain an exception log file. There are no exceptions neither
written
in this log file nor shown on page. We are not able to replicate
this issue.
We even asked user whether she does multiple clicks on submit
button or has
multiple sessions opened. But the user denies doing anything of
this.
>
Can anyone help me in this problem? What can be cause for this
issue?
Nov 29 '07 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
23117
by: Steve Jorgensen | last post by:
A while back, I started boning up on Software Engineering best practices and learning about Agile programming. In the process, I've become much more committed to removing duplication in code at a much finer level. As such, it's very frustrating to be working in VBA which lacks inheritance, one of the more powerful tools for eliminating duplication at the level I'm talking about. I've recently come up with a technique to emulate one...
2
1173
by: Aeden Jameson | last post by:
Supose you have NLB'd web servers with affinity set to none. A user fills out a form whose content will be written to a database. Also suppose the impatient user hits the submit button a second time. My question is, what do you need to detect the duplication submission?
2
1428
by: Beagle | last post by:
Hey all, I'm somewhat new to working with Access (aw geez, a noob) so I am hacking and slashing my way through creation of a database for a user at my job. The problem is this: I have created a form for tracking incoming calls and would like it to notify me when a call comes in from the same phone number. I would like it to notify me after the number has been entered by something like a color change or popup, so that I am aware of the...
10
2190
by: rave3085 | last post by:
I have 5 fields in my access table date,typeofexpenses,discription,amount,paymentmode. Now the problem is that i need to define a record by two fields-date and typeofexpenses. If the user tries to add a record which has both the date and typeofexpense field coinciding with a particular record in the database, then a msgbox should be displayed. Otherwise if only the date or only the typeofexpenses field is found coinciding, then the record should...
12
1375
by: nathan | last post by:
Hello, Has anyone experienced that records get duplicated by itself. When I look in my tables backend mdb file there are 2 records with the same information. I'm sure the frontend created this records. How can i solve this problem? There are 3 users that connect to the backend file on a windows 2003 share. My basic form uses subforms, and a search field combobox created by access. There is one table with clients, on table with...
3
1255
by: jeenajos | last post by:
Hi... Im having 12 tables in a database.Record contain mobileno,place,date. Records in one table will be duplicated in other. Wat query should i give to get unique mobileno in the whole 12 tables in the same format?? Pls help. Thanks in advance. Regards, Jeen
1
1569
by: dbarmer | last post by:
I have a unix database system that hold three tables, 254, 255, 256, and all are linked together by WO, CUST NO, LOC NO. This is for Unix Program Purposes Only. Duplication here is by design. So Up Front I have duplicated data due to a sequence work'd performed. For example. WO 000001 has duplicate WO, CUST, LOC etc... four times because it has four different Work Descriptions. SO, When I transfer these tables to access and create a...
1
2026
by: gurmet | last post by:
Hi All I have been looking around for help, and finally post this problem. I created a form to edit a record. Before i can click save button on the edit form i need to check if the data that have been edit exists in the table. But if i m calling the same record and updating the same record without changing anything it should allowed to save. Example: I m creating a table to save all types of courses (course_id, course_code,...
1
7287
by: xraive | last post by:
I have a problem with this. Currently I am trying Allen's code and i am not successful. Current Design Table1 (Main Form) TravelID (PK) ApprovedBY EntreredBy BudgetCode ExpenseCode
0
9711
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of...
0
9593
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10595
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10335
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9169
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7633
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6862
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5668
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4306
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.