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 LtdTel +44 1330 860550 Fax +44 1330 860880========================================http://www.asylumweb.comEmail: steve@asylumweb.comSkype: 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:
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 LtdTel +44 1330 860550 Fax +44 1330 860880========================================http://www.asylumweb.comEmail: steve@asylumweb.comSkype: 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)