Re: FlushDatabase Suggestion

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18081
interpreted = N
texte = >> Kenneth Grome wrote: > >> [deletefile path/to/old.db] >> [closedatabase path/to/old.db] >> [copyfile path=path/to/new.db&to=path/to/old.db] > >The deletefile doesn't do anything here because of the closedatabase.Yes it does, it moves the old.db file out of the folder it's sitting in -- so it doesn't get reloaded after the [closedatabase] tag and before the [copyfile] tag.If you don't want to delete the current db file, for example if you prefer to archive it instead, do this:[movefile path=path/to/old.db&to=path/to/archiveFolder/old.db[date]] [closedatabase path/to/old.db] [copyfile path=path/to/new.db&to=path/to/old.db]In my first example I used the [deletefile] tag to demonstrate *one way* to get the old.db file out of the folder it was sitting in. But of course you can move it out of that folder just as effectively by using the [movefile] tag as shown in my second example ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: FlushDatabase Suggestion (Pat McCormick 1998)
  2. Re: FlushDatabase Suggestion (Pat McCormick 1998)
  3. Re: FlushDatabase Suggestion (Pat McCormick 1998)
  4. Re: FlushDatabase Suggestion (Kenneth Grome 1998)
  5. Re: FlushDatabase Suggestion (bob 1998)
  6. Re: FlushDatabase Suggestion (bob 1998)
  7. Re: FlushDatabase Suggestion (bob 1998)
  8. Re: FlushDatabase Suggestion (Pat McCormick 1998)
  9. Re: FlushDatabase Suggestion (Pat McCormick 1998)
  10. Re: FlushDatabase Suggestion (Kenneth Grome 1998)
  11. Re: FlushDatabase Suggestion (Bob Minor 1998)
  12. Re: FlushDatabase Suggestion (Pat McCormick 1998)
  13. Re: FlushDatabase Suggestion (Bob Minor 1998)
  14. Re: FlushDatabase Suggestion (Pat McCormick 1998)
  15. Re: FlushDatabase Suggestion (Kenneth Grome 1998)
  16. Re: FlushDatabase Suggestion (Pat McCormick 1998)
  17. Re: FlushDatabase Suggestion (Kenneth Grome 1998)
  18. FlushDatabase Suggestion (Pat McCormick 1998)
>> Kenneth Grome wrote: > >> [deletefile path/to/old.db] >> [closedatabase path/to/old.db] >> [copyfile path=path/to/new.db&to=path/to/old.db] > >The deletefile doesn't do anything here because of the closedatabase.Yes it does, it moves the old.db file out of the folder it's sitting in -- so it doesn't get reloaded after the [closedatabase] tag and before the [copyfile] tag.If you don't want to delete the current db file, for example if you prefer to archive it instead, do this:[movefile path=path/to/old.db&to=path/to/archiveFolder/old.db[date]] [closedatabase path/to/old.db] [copyfile path=path/to/new.db&to=path/to/old.db]In my first example I used the [deletefile] tag to demonstrate *one way* to get the old.db file out of the folder it was sitting in. But of course you can move it out of that folder just as effectively by using the [movefile] tag as shown in my second example ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

Cold Fusion Buster (1997) return missing item (was:WebCat Sales) (1997) WebCat BeOS (2002) Errant Email. (1998) Return as Delimeter (2000) Multiple security dbs (1997) SSL Config for Webten on Mac (1998) Friday night shopping site joke (1997) PIXO (1997) Solved. was pulldown menu differences (2005) Help!!!! Purchases not going through! (1997) emailer on Windows Beta 18 (1997) [WebDNA] [BULK] strange triggers.db occurrence??? (2012) Strange intermittent WebDNA problems (2008) RE: Problems with dbcatalog.exe (1997) SKU number. (2000) RE: NewCart+Search with one click ? (1997) re:WebCatalog and Filemaker (1996) Enhancement Request for WebCatalog-NT (1996) WebCatalog can't find database (1997)