Re: Formulas.db + Users.db

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12174
interpreted = N
texte = >>I open up the formulas.db file and added a new formula (actually copied >>and pasted the price and changed the name), I then commited the database >>in the catalog administartion but it still doesn't recognise it. > Richard Wylie rickw@magna.com.au wrote: >I had this problem, I found that restarting Webstar worked. I tried >flushing the Webcatalog and Webstar caches and they didn't work either. >Only restarting webstar solved the problem. >There's got to be a way around this?I think what you are running into is that you forgot to close the DB _before_ the edits. If the DB is open when you do the edits it will be promptly overwritten by the DB held in RAM as soon as you close it or commit it (the RAM copy). It does lead to an interesting timing dance if you are trying to update a DB that is live and being used :-) -Sven_____________________________________________________________________ Sven U. Grenander BeeHive Technologies, Inc. http://www.bzzzzzz.com - with a WebCam in Pasadena, California _____________________________________________________________________ Associated Messages, from the most recent to the oldest:

    
>>I open up the formulas.db file and added a new formula (actually copied >>and pasted the price and changed the name), I then commited the database >>in the catalog administartion but it still doesn't recognise it. > Richard Wylie rickw@magna.com.au wrote: >I had this problem, I found that restarting Webstar worked. I tried >flushing the Webcatalog and Webstar caches and they didn't work either. >Only restarting webstar solved the problem. >There's got to be a way around this?I think what you are running into is that you forgot to close the DB _before_ the edits. If the DB is open when you do the edits it will be promptly overwritten by the DB held in RAM as soon as you close it or commit it (the RAM copy). It does lead to an interesting timing dance if you are trying to update a DB that is live and being used :-) -Sven_____________________________________________________________________ Sven U. Grenander BeeHive Technologies, Inc. http://www.bzzzzzz.com - with a WebCam in Pasadena, California _____________________________________________________________________ Sven U. Grenander

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:

[Sum] function? (1997) A dynamic database. (1997) emailer (1997) WebCat2b15MacPlugin - showing [math] (1997) Server crash (1997) RE: Can a database get stomped by simultaneous access? (1997) HomePage Caution (1997) Protect (1997) Time for a hard questions. (1997) Searching with a form (2000) Limiting user access to .tmpl files (1997) Summing fields (1997) [Announce] Newest Commerce Site based on WebCatalog (1997) PIXO support (1997) Displaying photo attached to first record (1997) New index for docs (1997) Changes to the List (1997) Re:quit command on NT (1997) WebCatalog Features (1997) date to days? (2005)