Re: database editor add field, etc.

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62291
interpreted = N
texte = Scott Szretter wrote: > I wrote a quick database list fields / add field script, but was > wondering if there was a way to do a delete field from a database? Or, > other mods like maybe rename field? Scott,.. first, I think you are referring to "fieldnames"... which probably should be specified. To answer your question, sure, A webdna database is just a text file... so you can really do anything you want with the file so long as you play within the rules of the webdna database. Renaming a field is not a problem because the structure is still intact (commit .db after renaming). If you are not dynamically generating the calls for the fieldnames, you would have to rename those as well. Deleting a database fieldname is more tricky. For example, If you want to delete a fieldname in the middle of the fieldname string, you will have to keep in mind that you will have to edit the data to reflect the change. In this case, you may consider generating an entirely new database file (that replaces the old) containing only the fieldnames (with values) that are wanted. You could make this a pretty slick process by first creating a backup of the original database (by renaming it), then writing out the new .db with the original name. You will want to commit the database after it is done. HTH, 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), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Euca Design Center 1871 HWY MM Fitchburg, WI 53575 PH:> 1.608.835.2476 Web:> http://www.euca.us =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: database editor add field, etc. ( Donovan Brooke 2005)
  2. database editor add field, etc. ( Scott Szretter 2005)
Scott Szretter wrote: > I wrote a quick database list fields / add field script, but was > wondering if there was a way to do a delete field from a database? Or, > other mods like maybe rename field? Scott,.. first, I think you are referring to "fieldnames"... which probably should be specified. To answer your question, sure, A webdna database is just a text file... so you can really do anything you want with the file so long as you play within the rules of the webdna database. Renaming a field is not a problem because the structure is still intact (commit .db after renaming). If you are not dynamically generating the calls for the fieldnames, you would have to rename those as well. Deleting a database fieldname is more tricky. For example, If you want to delete a fieldname in the middle of the fieldname string, you will have to keep in mind that you will have to edit the data to reflect the change. In this case, you may consider generating an entirely new database file (that replaces the old) containing only the fieldnames (with values) that are wanted. You could make this a pretty slick process by first creating a backup of the original database (by renaming it), then writing out the new .db with the original name. You will want to commit the database after it is done. HTH, 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), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Euca Design Center 1871 HWY MM Fitchburg, WI 53575 PH:> 1.608.835.2476 Web:> http://www.euca.us =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:

error in online 3.x docs - makes it impossible to read about file formats (2000) Template transformed itself into a database? (1998) PCS Customer submissions ? (1997) Sort Order on a page search (1997) [format xs] freeze (1997) Emailer not working (1998) Rhapsody? (1997) PCS Frames (1997) too many files! (2006) Forms Search Questions (1997) Multiple catalog databases and showcart (1997) Thanks Grant (1997) Re:Searching for ALL / empty form field (1997) Problems with [Applescript] (1997) Email within tmpl ? (1997) AccountAuthorizer doesn't seem to work (1997) WebDNA v5 Hosting (2003) how to do multiple prices/item? (1998) RE: Missing contexts on NT (1997) Configuring E-mail (1997)