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:

HideIf ip= OR ip= (1998) RE: Formulas.db + Users.db (1997) searching multiple databases (1997) Hard Questions ? (1997) Sum of Quantities (1997) Purchased cart being overwritten - still !?? (1997) Summing fields (1997) Multiple Merchant Accounts? (1997) [SearchString] problem with [search] context (1997) Plugin or CGI or both (1997) Falsifying [BROWSERNAME] (1998) Firewalls - What's Good? (1999) F3 crashing server (1997) PCS Customer submissions ? (1997) Possible Macv2.1b2 Merge Bug (1997) Multiple fields on 1 input (1997) Help name our technology! (1997) For those of you not on the WebCatalog Beta... (1997) Invoice Data Fields (1999) [WebDNA] Search encrypted field (2015)