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:

Occasional crashes with $remove (1997) page redirect in webDNA (1997) [WebDNA] [OT] ImageMagick or similar (2015) New Shipping Options? (2001) OT: Making demo movies (2002) why is this line in GeneralStore? (1998) Calendar (1997) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) RE: IIS4b2 and WebCatalog b19 (1997) Summing fields (1997) Remote delivery (1998) WebCat2b12--[searchstring] bug (1997) WebCat2b12 forgets serial # (1997) Bugs in IE 6.0 ? (2003) RePost: NAT and the CART (1999) OT: Collaborative Browsing (2000) Anyone get webdna to run on apache 2.x on osx? (2006) 2 passwords (2003) Pop-up menu (1998) Message Boards (2003)