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

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 55113
interpreted = N
texte = >But you could SEARCH with max=1, use REPLACEFOUNDITEMS to modify the >one found record, then DELETE the modified record. Or, if you may >have multiple duplicate records, you could SEARCH with startat=2, >leaving the first record alone and modifying then deleting all the >duplicates. I simply posted the code I have been using. You *could* do it a number of different ways ... -- 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)
>But you could SEARCH with max=1, use REPLACEFOUNDITEMS to modify the >one found record, then DELETE the modified record. Or, if you may >have multiple duplicate records, you could SEARCH with startat=2, >leaving the first record alone and modifying then deleting all the >duplicates. I simply posted the code I have been using. You *could* do it a number of different ways ... -- 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:

Emailer choke (1997) Just Testing (1997) New Weird Behavior (bug report) (2000) Extended [Convertchars] needed (1997) Plaintext Email Attachment (2001) pop up menu's (1998) ANother SHOWIF problem (1997) Re:emailer 150 (1997) PCS Frames-Default page is solution! (1997) Almost There WebCat 5 on itools 7 Install Questions (2003) Another new bug found ... (2000) WC2b12: Yes, Formulas.db is for real (1997) checkbox results written to a database (1999) [WebDNA] Searching for encrypted values (2014) More to Expire (1998) Spell Check (2005) Sort Order on a page search (1997) bypassing typo's (1998) [shownext max (1997) Busy WebCatalog (2000)