Re: Remove a Field from a DB
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69107
interpreted = N
texte = 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 >>Palle >Gary, so what should I do in the text editor. You know any text >editor with some advanced tools which can delete and entire column >without affecting other parts of the doc. incl. other columns? > >Palle -- 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:
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 >>Palle >Gary, so what should I do in the text editor. You know any text >editor with some advanced tools which can delete and entire column >without affecting other parts of the doc. incl. other columns? > >Palle -- 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:
JavaScript question (2001)
Nesting WebDNA in JavaScript (2003)
Some Advise needed (1997)
[WebDNA] Google Map Mashup available at webdna.us (2010)
re:check boxes (1997)
help (2003)
[WebDNA] WebDNA restart script (2015)
Can GMT be called from the OS ? (2004)
Crazy dates (was: sorting dates) (1999)
[WebDNA] A new commerce system for v7+ (2011)
Nutscrape Doesn't Render Right (2002)
Encryption Question (2006)
Test (2003)
Searchable WebCat (etc.) Docs ? (1997)
Looking for 5 to 12 shops with 3 URLs & statements (1997)
[MATH] and Dates (1998)
Server crash (1997)
Merchant and WebCat 3.0 (1998)
WebCatalog2 Feature Feedback (1996)
Finding max value for a field (1997)