Topic: Duplication of Entry
Just wanna ask if there's a way to prevent duplication of entry?
i'm making a data entry system and i noticed that if you enter a same data it will duplicate, pls see my screenshot..
My Visual Database → Database applications → Duplication of Entry
Just wanna ask if there's a way to prevent duplication of entry?
i'm making a data entry system and i noticed that if you enter a same data it will duplicate, pls see my screenshot..
Just wanna ask if there's a way to prevent duplication of entry?
i'm making a data entry system and i noticed that if you enter a same data it will duplicate, pls see my screenshot..
if you need to optimize the database
denzkie1191 wrote:Just wanna ask if there's a way to prevent duplication of entry?
i'm making a data entry system and i noticed that if you enter a same data it will duplicate, pls see my screenshot..
if you need to optimize the database
hello sir, i got the sample that you've made, can you pls. explain what is happening in your sample?
sorry sir i'm new to this application, i noticed u used script, but too bad for me sir i don't know how to code yet in this platform.
thank you for your effort sir.. i appreciated it.
Hi Denzkie, Sibprogsistem,
I don't think it's possible to check for duplicate entries without writing a script. However, it needn't be complicated.
Please see the attached as a simple duplicate check (there are other ways but they involve more lines of code); there is a more detailed explanation in the script comments.
Shout out if anything's not clear and I'm sure someone will try and lend a hand.
Derek.
hello sir, i got the sample that you've made, can you pls. explain what is happening in your sample?
sorry sir i'm new to this application, i noticed u used script, but too bad for me sir i don't know how to code yet in this platform.
thank you for your effort sir.. i appreciated it.
this script checks if such a name exists in the database, if it does not exist, then adds it, and if it exists, a new record is associated with it
denzkie1191,
Attached is another option. As you can see, MVD is very flexible in doing things in various ways. Not one is really any better than the other.
Hi Denzkie, Sibprogsistem,
I don't think it's possible to check for duplicate entries without writing a script. However, it needn't be complicated.
Please see the attached as a simple duplicate check (there are other ways but they involve more lines of code); there is a more detailed explanation in the script comments.
Shout out if anything's not clear and I'm sure someone will try and lend a hand.
Derek.
thank you sir..
denzkie1191 wrote:hello sir, i got the sample that you've made, can you pls. explain what is happening in your sample?
sorry sir i'm new to this application, i noticed u used script, but too bad for me sir i don't know how to code yet in this platform.
thank you for your effort sir.. i appreciated it.
this script checks if such a name exists in the database, if it does not exist, then adds it, and if it exists, a new record is associated with it
ow i see, thank you sir..
denzkie1191,
Attached is another option. As you can see, MVD is very flexible in doing things in various ways. Not one is really any better than the other.
thank you for helping me sir..
Dear Ehwagner. I used yor application, added the fields "Address" and "City". Deletedmyour records en add two new records. So far all is well, but changing an address is impossible, because the programm doesnot recognize that this is not adding a new record and displays the massagebox. Do you have a solution
kees.krause,
If you want to use my solution I updated the project and added address and then checked for a duplicate after making changes to a record. So if the user updates the fields and the result of the changes will produce a duplicate then present the duplicate error message otherwise it will save the changed data. If you do not want to use the address as part of the duplicate check, then remove it from the SQLEXECUTE statements and the Hold_Flds and FLD_Concat variables.
Hi Kees, Hi EHW,
Duplicates - what a nightmare - LOL!
I've tried to cover all the options in the attachment (I'm only considering 'first name' and 'last name' duplicates (date of birth, city - anything - can be included but I didn't want to complicate the issue)).
So,
1. a new record with the same first name and last name is a duplicate
2. an existing record that has a date of birth and / or city added is saved as an existing record
3. if an existing record changes the first name and last name to a first name and last name that doesn't already exist, this is saved as an existing record.
4. if an existing record changes the first name and last name to a first name and last name that already exists, this is a duplicate.
As extra safeguards, there are checks for a mixture of upper and lower cases and for leading and trailing spaces (typically data entry errors).
Derek.
Hello Derek and Ehwagner.
Both thanks for your reaction. For Ehwagner the changed project is enclosed. Derek is will study your project.
kees.krause,
See my earlier post which includes a revised project (Dup Check Revised.zip)
My Visual Database → Database applications → Duplication of Entry
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi