Re: Remove a Field from a DB

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69111
interpreted = N
texte = >Terry Wilson wrote: >> I would just search the DB for the deprecated field, find all, >>andreplace with no value. Then open the DB in a text editor like >>BBEdit anddelete the field name, save, and reload the DB. >>If opening the DB in a text editor is an issue, just fix your code >>sothe deprecated field is no longer used. It won't hurt anything. I >>oftenhave unused fields in my DBs anyway (for future expansion or >>becuase itis no longer used). >>Terry > > >Make a back up if you use Terry's method. ;-) > >Donovan Good idea -- if your field names are abstract, make sure to specify the correct field! Otherwise, [replace db=stuff&etc]deprecatedfield=[/replace] is pretty straightforward. I would do a search first and look at the founditems before doing something big. If all is okay, then edit the search into a replace. Terry -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- 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: Remove a Field from a DB ( Terry Wilson 2007)
  2. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  3. Re: Remove a Field from a DB ( Terry Wilson 2007)
  4. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  5. Re: Remove a Field from a DB ( Terry Wilson 2007)
  6. Re: Remove a Field from a DB ( Steve Craig 2007)
  7. Re: Remove a Field from a DB ( Matthew Bohne 2007)
  8. Re: Remove a Field from a DB ( Larry Hewitt 2007)
  9. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  10. Re: Remove a Field from a DB ( Gary Krockover 2007)
  11. Re: Remove a Field from a DB ( Palle Bo Nielsen 2007)
  12. Re: Remove a Field from a DB ( Palle Bo Nielsen 2007)
  13. Re: Remove a Field from a DB ( Palle Bo Nielsen 2007)
  14. Re: Remove a Field from a DB ( Gary Krockover 2007)
  15. Re: Remove a Field from a DB ( Matthew Bohne 2007)
  16. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  17. Remove a Field from a DB ( Palle Bo Nielsen 2007)
>Terry Wilson wrote: >> I would just search the DB for the deprecated field, find all, >>andreplace with no value. Then open the DB in a text editor like >>BBEdit anddelete the field name, save, and reload the DB. >>If opening the DB in a text editor is an issue, just fix your code >>sothe deprecated field is no longer used. It won't hurt anything. I >>oftenhave unused fields in my DBs anyway (for future expansion or >>becuase itis no longer used). >>Terry > > >Make a back up if you use Terry's method. ;-) > >Donovan Good idea -- if your field names are abstract, make sure to specify the correct field! Otherwise, [replace db=stuff&etc]deprecatedfield=[/replace] is pretty straightforward. I would do a search first and look at the founditems before doing something big. If all is okay, then edit the search into a replace. Terry -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- 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/ Terry Wilson

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:

Sorting when searching with grouped fields (2002) PCS Customer submissions ? (1997) syntax question, not in online refernce (1997) WebCat2: Formulas.db question (1997) Share cost of training videos! (1998) CGI Request Time Out (1997) combine search (1998) 2nd WebCatalog2 Feature Request (1996) Webcat 3 Bug?!?! Netscape + Protect + Posted Form (1998) Is it possible to pause or wait a process (2000) purchase.log file (1997) For those of you not on the WebCatalog Beta... (1997) [Format thousands .2f] and negative values (2001) limit to listwords (2001) Searching an Email database (1997) Calculating multiple shipping... (1997) problems with 2 tags (1997) shipCost formula (1997) What are SMSI's upgrade policies? (2003) RE: Cookies? (1997)