Re: Remove a Field from a DB
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69112
interpreted = N
texte = Terry Wilson wrote: >> 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, I was trying to politely hint that if one was to replace field values with nothing.. then delete the field name, the database would then be munged. "Munged" <-- Donovan's favorite descriptive for messed up databases. Your idear may/may not work if the fieldname column was the last in the fieldname line... (Not sure if the WebDNA engine would auto truncate the the last column) btw, how did that Apple thing work out for you? 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:
Terry Wilson wrote: >> 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, I was trying to politely hint that if one was to replace field values with nothing.. then delete the field name, the database would then be munged. "Munged" <-- Donovan's favorite descriptive for messed up databases. Your idear may/may not work if the fieldname column was the last in the fieldname line... (Not sure if the WebDNA engine would auto truncate the the last column) btw, how did that Apple thing work out for you? 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:
Avery 5160 Mailing Labels (2003)
[date] for today's date, while inside old order file (1998)
Batch printing of web pages (2003)
WebDNA 4.5.1 Now Available (2003)
Problems deleting when a search field is blank... (1998)
For those of you not on the WebCatalog Beta... (1997)
More questions about serial number dishing (1997)
WebTen and WebCat (1997)
carriage returns in data (1997)
Web Hosters with WebCatalog support (2000)
Sorting Numbers (1997)
Emailer setup (1997)
SSL Certs (2003)
First postarg not taking in $Commands (1997)
adding up in a db (1997)
[WriteFile] problems (1997)
Limiting user access to .tmpl files (1997)
WebDNA server not running (2003)
Clean source code (2007)
WebCat2_Mac RETURNs in .db (1997)