Re: Remove a Field from a DB
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69093
interpreted = N
texte = FileMaker Pro is an excellent product for doing database conversions in partnership with WebDNA. Have used it for years - worth the investment. Simply open the file with FMP, it correctly parses the database and you can leave the first record to remain the field names if that is how you use WebDNA, then export without the field you want to remove. That simple. Larry Larry Hewitt 360.807.1100 OFFICE The REQ Center, LLC 360.807.1103 FAX 109 No. Tower 360.880.4855 CELL P.O. Box 1017 larryh@hewittco.com Centralia, WA 98531 larryh@thereq.com TheREQ.com On Jun 20, 2007, at 10:28 AM, Palle Bo Nielsen wrote: > What you are asking me is to move approx. 150MB of data using this > method. I have tried that method and it brings me a timeout in the > browser when activation this code snippet. So the task is never > completed. > > Any good suggestions on avoiding the browser time out. > > Server: Mac OS X 10.4.9; 2GB; WebDNA 6.x > > Palle > > > > > On 20/06/2007, at 16.05, Donovan Brooke wrote: > >> Palle Bo Nielsen wrote: >>> Two questions? >>> a) anyone having major trouble getting things through to the >>> WebDNA talk list? >> >> >> nope >> >>> b) any good suggestions on how to remove a Field and all it's >>> content from a database? >>> Palle >> >> [!] ** Back Up ** [/!] >> [copyfile from=olddb.db&to=olddb.db.bu] >> >> [writefile.. new_fields.db]
[/writefile] >> >> [search db=olddb.db ..find_all] >> [append db=new_fields.db] >> [/search] >> >> [movefile from=new_fields.db&to=olddb.db] >> >> [commitdatabase db=olddb.db] >> >> >> -- >> =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 > digest@talk.smithmicro.com> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > > -- > Venlig hilsen > Palle B. Nielsen (PowerPalle) > http://www.macnyt.dk/ > iChat: powerpalle > > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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:
FileMaker Pro is an excellent product for doing database conversions in partnership with WebDNA. Have used it for years - worth the investment. Simply open the file with FMP, it correctly parses the database and you can leave the first record to remain the field names if that is how you use WebDNA, then export without the field you want to remove. That simple. Larry Larry Hewitt 360.807.1100 OFFICE The REQ Center, LLC 360.807.1103 FAX 109 No. Tower 360.880.4855 CELL P.O. Box 1017 larryh@hewittco.com Centralia, WA 98531 larryh@thereq.com TheREQ.com On Jun 20, 2007, at 10:28 AM, Palle Bo Nielsen wrote: > What you are asking me is to move approx. 150MB of data using this > method. I have tried that method and it brings me a timeout in the > browser when activation this code snippet. So the task is never > completed. > > Any good suggestions on avoiding the browser time out. > > Server: Mac OS X 10.4.9; 2GB; WebDNA 6.x > > Palle > > > > > On 20/06/2007, at 16.05, Donovan Brooke wrote: > >> Palle Bo Nielsen wrote: >>> Two questions? >>> a) anyone having major trouble getting things through to the >>> WebDNA Talk List? >> >> >> nope >> >>> b) any good suggestions on how to remove a Field and all it's >>> content from a database? >>> Palle >> >> [!] ** Back Up ** [/!] >> [copyfile from=olddb.db&to=olddb.db.bu] >> >> [writefile.. new_fields.db][/writefile] >> >> [search db=olddb.db ..find_all] >> [append db=new_fields.db] >> [/search] >> >> [movefile from=new_fields.db&to=olddb.db] >> >> [commitdatabase db=olddb.db] >> >> >> -- >> =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 > digest@talk.smithmicro.com> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > > -- > Venlig hilsen > Palle B. Nielsen (PowerPalle) > http://www.macnyt.dk/ > iChat: powerpalle > > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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/
Larry Hewitt
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:
_ in front of field name (1998)
WebCat2b15MacPlugin - [protect] (1997)
about this server and links to who (1997)
PCS Frames-Default page is solution! (1997)
date pref (1999)
Beta 18 (1997)
Country & Ship-to address & other fields ? (1997)
Can ShowNext do this? (2000)
Authenticate (1997)
Emailer problems solved (1997)
Erotic Sites (1997)
problems with 2 tags shakur (1997)
Plugin or CGI or both (1997)
[WebDNA] jumpstart me? - how to auto-upload to a remote server? (2010)
[WebDNA] sort parameters in search (2015)
Email within tmpl ? (1997)
[BULK] [WebDNA] Can WebDNA corrupt a db? (2012)
Bug or syntax error on my part? (1997)
drop down list (2000)
Sending an email to all )or some) email addresses int he database (1999)