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


Groups > comp.lang.clipper.visual-objects > #3388 > unrolled thread

Close all open DBFs and reopen

Started byMartin <spam@spam.spam>
First post2012-05-02 12:37 +0100
Last post2012-05-02 22:21 -0700
Articles 2 on this page of 22 — 8 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

Page 2 of 2 — ← Prev page 1 [2]


#3391

From"Stephen Quinn" <stevejqNO@bigpondSPAM.net.au>
Date2012-05-03 02:02 +1000
Message-ID<r_cor.6574$%E2.5283@viwinnwfe01.internal.bigpond.com>
In reply to#3388
Martin

> I want to close all of the files in use, then reopen them in the same 
> workareas and server instances, how easy is this to do?

To open them in the same workareas you'd need to track the order in which 
they we opened in the first place. IIRC dbservers are allocated from the top 
down and Clipper style USE command are opened bottom up (or vice versa, it's 
in the help somewhere) (there  are 1024 work areas available)

If your servers are attached to windows then you'll need to close them as 
well.

You won't get the same instances as once the object is destroyed (ie when 
you close it) it's gone, never to see the light of day again<g>

So it begs the question - why do you want to do this??

CYA
Steve

[toc] | [prev] | [next] | [standalone]


#3395

FromMathias <mathias.hakansson@consultec.se>
Date2012-05-02 22:21 -0700
Message-ID<30152619.1951.1336022486287.JavaMail.geo-discussion-forums@vbki8>
In reply to#3388
Hello Martin,

In my application I close the server objects, copy the files to a zip-fil, and opens them again, without the user noticing anything more than a short time (half a second) with the hourglass. The trick is to do a SuspendNotification first. If you don't you loose the columns. After saving the files, the server objects are recreated, correct sort order and active record is set and after that I do a simple Use on the datawindow. The user may have several project windows opened. This is hadled by keeping av array of all opened project windows. Before save the "PreSave" method is called in all opened windows and after PostSave is called. In PreSave the active record number and the filter is stored. In PostSave these properties are set again and Use is called.

/Mathias

Den onsdagen den 2:e maj 2012 kl. 13:37:50 UTC+2 skrev Martin:
> Hello
> 
> I want to close all of the files in use, then reopen them in the same 
> workareas and server instances, how easy is this to do?

[toc] | [prev] | [standalone]


Page 2 of 2 — ← Prev page 1 [2]

Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web