Re: Remove a Field from a DB

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69108
interpreted = N
texte = Terry Wilson wrote: > I would just search the DB for the deprecated field, find all, and > replace with no value. Then open the DB in a text editor like BBEdit and > delete the field name, save, and reload the DB. > > If opening the DB in a text editor is an issue, just fix your code so > the deprecated field is no longer used. It won't hurt anything. I often > have unused fields in my DBs anyway (for future expansion or becuase it > is no longer used). > > Terry Make a back up if you use Terry's method. ;-) Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:>(608) 835-2476 TALK:>http://artglass-forum.com WEB:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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, and > replace with no value. Then open the DB in a text editor like BBEdit and > delete the field name, save, and reload the DB. > > If opening the DB in a text editor is an issue, just fix your code so > the deprecated field is no longer used. It won't hurt anything. I often > have unused fields in my DBs anyway (for future expansion or becuase it > is no longer used). > > Terry Make a back up if you use Terry's method. ;-) Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:>(608) 835-2476 TALK:>http://artglass-forum.com WEB:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/ Donovan Brooke

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:

This list needs a digest: rant, rave... (1997) Error - Search / Showif (2000) Header info in content (1998) [WebDNA] OT: Translation Services (2008) Time code! (2002) Security Question (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) need some help with a loop (1999) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) hidden (phantom) file downloads (2000) [WebDNA] Different responses for the same commands ... (2011) Nesting Search Within Tag? (1997) WebDNA Writer Needed (1997) WC Database Format (1997) So many lookers, hey smith micro (2003) HomePage Caution (1997) SiteGaurd file Cache vs webcatalog cache (1997) Intermitent problem using [referrer] (1997) syntax question, not in online refernce (1997) Multiple Pulldowns (1997)