Re: how do I delete 1 of 2 identical records?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 55108
interpreted = N
texte = >I have a database that at one point had some poor add record code. >As a result, one record has been duplicated exactly. Any time this >record is updated both records are updated. I need to delete 1 of >these records, but so far my test attempts have resulted in deleting >both (using a test database of course). All you have to do is create a way to distinguish between the two records, then delete only one of them. Here's a simple solution that adds a new field to the db so you can use it to distinguish one record from another uniquely. Then it deletes one of the two (or three or four or more) previously identical records. This code will delete all but one record in each set of duplicate (triplicate, quadruplicate, etc.) records in the db, not just the first one it finds. It is a one-step solution. The only two things it requires is that you use a field named "sku" that is supposed to have a unique value in it for each record, and that you also use a ..hdr file for the db you're trying to fix: [text]deleteList=[/text] [text]mostOfTheDbHeaderFile=[getchars start=2&from=end][include xxx.hdr][/getchars][/text] [closedatabase xxx.db] [writefile xxx.hdr][mostOfTheDbHeaderFile]newField [/writefile] [search db=xxx.db&neskudatarq=[blank]&asskusort=1] [replacefounditems][newField]=[index][/replacefounditems] [founditems] [showif [lastSKU]=[sku]] [text]deleteList=[deleteList],[newField][/text] [/showif] [text]lastSKU=[sku][/text] [/founditems] [/search] [delete db=xxx/db&wonewFielddatarq=[deleteList]&newFieldword=ww] -- Kenneth Grome ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: how do I delete 1 of 2 identical records? ( Kenneth Grome 2003)
  2. Re: how do I delete 1 of 2 identical records? ( Brian Fries 2003)
  3. Re: how do I delete 1 of 2 identical records? ( Grant Hulbert 2003)
  4. Re: how do I delete 1 of 2 identical records? ( "Andrew Simpson" 2003)
  5. Re: how do I delete 1 of 2 identical records? ( Kenneth Grome 2003)
  6. Re: how do I delete 1 of 2 identical records? ( Brian Fries 2003)
  7. Re: how do I delete 1 of 2 identical records? ( "Matthew Bohne" 2003)
  8. Re: how do I delete 1 of 2 identical records? ( Kenneth Grome 2003)
  9. Re: how do I delete 1 of 2 identical records? ( "Andrew Simpson" 2003)
  10. Re: how do I delete 1 of 2 identical records? ( Kenneth Grome 2003)
  11. Re: how do I delete 1 of 2 identical records? ( Gary Krockover 2003)
  12. how do I delete 1 of 2 identical records? ( CN Stuff 2003)
>I have a database that at one point had some poor add record code. >As a result, one record has been duplicated exactly. Any time this >record is updated both records are updated. I need to delete 1 of >these records, but so far my test attempts have resulted in deleting >both (using a test database of course). All you have to do is create a way to distinguish between the two records, then delete only one of them. Here's a simple solution that adds a new field to the db so you can use it to distinguish one record from another uniquely. Then it deletes one of the two (or three or four or more) previously identical records. This code will delete all but one record in each set of duplicate (triplicate, quadruplicate, etc.) records in the db, not just the first one it finds. It is a one-step solution. The only two things it requires is that you use a field named "sku" that is supposed to have a unique value in it for each record, and that you also use a ..hdr file for the db you're trying to fix: [text]deleteList=[/text] [text]mostOfTheDbHeaderFile=[getchars start=2&from=end][include xxx.hdr][/getchars][/text] [closedatabase xxx.db] [writefile xxx.hdr][mostOfTheDbHeaderFile]newField [/writefile] [search db=xxx.db&neskudatarq=[blank]&asskusort=1] [replacefounditems][newField]=[index][/replacefounditems] [founditems] [showif [lastSKU]=[sku]] [text]deleteList=[deleteList],[newField][/text] [/showif] [text]lastSKU=[sku][/text] [/founditems] [/search] [delete db=xxx/db&wonewFielddatarq=[deleteList]&newFieldword=ww] -- Kenneth Grome ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Kenneth Grome

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Disappearing HTML/WebDNA (1998) OFF-TOPIC: Lending investors ... (2002) Try not to laugh (2007) Major Security Hole IIS NT (1998) Linebreak as a delimiter in listwords? (2003) Displaying photo attached to first record (1997) WebCat2 several catalogs? (1997) [shownext] help (2002) Thanks ! (1997) A better WebCat whois (was [OT] Domain Name Scam) (2000) More than one db with the same namn (was: WC2f3) (1997) WebCat and WebTV (1997) [WebDNA] Win 10 FastCGI not running (2019) append duplication help (2000) RE: Can a database get stomped by simultaneous access? (1997) suffix mapping for NT? (1997) Sample Tearoom Search Error (1997) frames & carts (1997) IPADDRESS mystery (2003) Re(5): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)