Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #3403

Re: Close all open DBFs and reopen

From Mathias <mathias.hakansson@consultec.se>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Close all open DBFs and reopen
Date 2012-05-04 00:20 -0700
Organization http://groups.google.com
Message-ID <27407326.489.1336116052048.JavaMail.geo-discussion-forums@vbx14> (permalink)
References <b09or.180034$Od1.45938@fx32.am4> <on92q7lqd9u6h6jiai6duue2umiibiupmv@4ax.com> <r_cor.6575$%E2.1837@viwinnwfe01.internal.bigpond.com> <paa3q7ptbgtets7oqhjt4rlhiknge2eccg@4ax.com> <nPror.537498$xD4.284957@fx06.am4>

Show all headers | View raw


Sorry if my post was misleading. The files that I pack are used exclusively used by one user. Infact the zip file is an estimation project file with a special suffix so that users don't open it as a zip. The project file is unpacked in a temporary directory and are used by one user only. 

What I wanted to do was to give you some clues to how you can close the databases and open them again without disturbing the user too much, even if the user is browsing data in a databrowser or datawindow.

If you want to make a backup while the files are used you have to use shadow copy. I haven't done this myself, but I'm using Coban backup (www.cobiansoft.com) for my own purposes and this freeware backup product can backup files that are currently being used.

/Mathias

Den torsdagen den 3:e maj 2012 kl. 11:01:14 UTC+2 skrev Martin:
> Thanks all I will have a nose through
> 
> It is so a database update can be done without quitting the application, 
> but file has to be closed then reopened to use the new file format. 
> Planning to send a message from the updating program to tell the other 
> users to do a close open.
> 
> But more excited about the pack while in shared mode.
> 
> On 02/05/2012 22:47, Karl Faller wrote:
> > Steve,
> >>> firstly, i think there's some mismatch - "same workareas" vs "same
> >>> server instance". The DBServer handles the WA behind the scenes, and
> >>> there's NO guarantee to get any special WA "number" assigned.
> >>
> >> I think you'll find that the WA is assigned consecutively 0 ->1023 (or
> >> 1023->0) when using servers.
> > Yes.
> > (BTW, in VN it is 4095, caused me some head scratching why my "list
> > WAs in use" func stopped working after transportation ;-)
> >
> > But exactly _which_ number you get for any given server instance
> > depends on the amount of other used WAs. So i wanted to suggest
> > avoiding this mismatch - either work on WA numbers, OR with DBServer
> > instances, but not both, and certainly not to close and
> > reopen/recreate - this calls for dragons...
> >
> > HAND
> > Karl

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-02 12:37 +0100
  Re: Close all open DBFs and reopen Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2012-05-02 14:27 +0200
    Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-03 02:09 +1000
      Re: Close all open DBFs and reopen Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2012-05-02 23:47 +0200
        Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-03 10:01 +0100
          Re: Close all open DBFs and reopen Mathias <mathias.hakansson@consultec.se> - 2012-05-04 00:20 -0700
            Re: Close all open DBFs and reopen "richard.townsendrose" <richard.townsendrose@gmail.com> - 2012-05-04 05:21 -0700
              Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-04 14:10 +0100
            Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-04 14:10 +0100
              Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-05 00:45 +1000
                Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-08 14:04 +0100
          Re: Close all open DBFs and reopen dlzc <dlzc1@cox.net> - 2012-05-04 09:24 -0700
            Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-05 03:15 +1000
            Re: Close all open DBFs and reopen D.J.W. van Kooten <public@ic2remove.this.com> - 2012-05-06 23:00 +0200
              Re: Close all open DBFs and reopen dlzc <dlzc1@cox.net> - 2012-05-06 15:38 -0700
                Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-07 11:57 +1000
                Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-08 14:08 +0100
            Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-08 14:06 +0100
              Re: Close all open DBFs and reopen Karl Wochele <kw@e©os-system.de> - 2012-05-08 15:28 +0200
    Re: Close all open DBFs and reopen D.J.W. van Kooten <public@ic2remove.this.com> - 2012-05-02 19:56 +0200
  Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-03 02:02 +1000
  Re: Close all open DBFs and reopen Mathias <mathias.hakansson@consultec.se> - 2012-05-02 22:21 -0700

csiph-web