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"... whichprobably should be specified. To answer your question, sure, Awebdna database is just a text file... so youcan really do anything you want with the file so long as you playwithin the rules of the webdna database. Renaming a field is nota problem because the structure is still intact (commit .db after renaming).If you are not dynamically generating the calls for the fieldnames, you wouldhave to rename those as well.Deleting a database fieldname is more tricky. For example, Ifyou 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 toreflect the change. In this case, you may consider generating anentirely new database file (that replaces the old) containing onlythe fieldnames (with values) that are wanted. You could make this apretty 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:
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"... whichprobably should be specified. To answer your question, sure, Awebdna database is just a text file... so youcan really do anything you want with the file so long as you playwithin the rules of the webdna database. Renaming a field is nota problem because the structure is still intact (commit .db after renaming).If you are not dynamically generating the calls for the fieldnames, you wouldhave to rename those as well.Deleting a database fieldname is more tricky. For example, Ifyou 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 toreflect the change. In this case, you may consider generating anentirely new database file (that replaces the old) containing onlythe fieldnames (with values) that are wanted. You could make this apretty 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)