Re: Remove a Field from a DB

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69104
interpreted = N
texte = I would second that one, I use it as well with no problems. If you want I'll remove the field for you if you send me the file. Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1330 860550 Fax +44 1330 860880 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com Skype: s.craig - iChat: steve.craig ======================================== On 20 Jun 2007, at 19:37, Larry Hewitt wrote: > 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 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:

    
  1. Re: Remove a Field from a DB ( Terry Wilson 2007)
  2. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  3. Re: Remove a Field from a DB ( Terry Wilson 2007)
  4. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  5. Re: Remove a Field from a DB ( Terry Wilson 2007)
  6. Re: Remove a Field from a DB ( Steve Craig 2007)
  7. Re: Remove a Field from a DB ( Matthew Bohne 2007)
  8. Re: Remove a Field from a DB ( Larry Hewitt 2007)
  9. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  10. Re: Remove a Field from a DB ( Gary Krockover 2007)
  11. Re: Remove a Field from a DB ( Palle Bo Nielsen 2007)
  12. Re: Remove a Field from a DB ( Palle Bo Nielsen 2007)
  13. Re: Remove a Field from a DB ( Palle Bo Nielsen 2007)
  14. Re: Remove a Field from a DB ( Gary Krockover 2007)
  15. Re: Remove a Field from a DB ( Matthew Bohne 2007)
  16. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  17. Remove a Field from a DB ( Palle Bo Nielsen 2007)
I would second that one, I use it as well with no problems. If you want I'll remove the field for you if you send me the file. Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1330 860550 Fax +44 1330 860880 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com Skype: s.craig - iChat: steve.craig ======================================== On 20 Jun 2007, at 19:37, Larry Hewitt wrote: > 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 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/ Steve Craig

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:

Follow-up to listfiles bug report ... (2003) Multiple TCPConnects (2002) where did it find it? (2000) [WebDNA] Using WebDNA with MAMP (2010) Some Questions (1997) [sendmail] questions... (1997) WebCatalog and directory indexing (1998) Re1000001: Setting up shop (1997) Don't tick me off :) [elaspedtime] (1997) WebCatalog can't find database (1997) HTML encoding in URLs (1997) Error Lob.db records error message not name (1997) Calculating multiple shipping... (1997) WebCatalog for Postcards ? (1997) Images in WebCat (2000) WebCat editing, SiteGuard & SiteEdit (1997) [WebDNA] why is the webdna.us site slow? (sometimes?) (2011) Webcatalog on MacOs (2000) updating with ProductEditor (1998) Protecting Realms (1998)