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


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

help

Started byaurora baccio <aurorabaccio@gmail.com>
First post2021-06-12 23:38 -0700
Last post2021-06-16 09:08 +0200
Articles 5 — 3 participants

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


Contents

  help aurora baccio <aurorabaccio@gmail.com> - 2021-06-12 23:38 -0700
    Re: help "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-06-15 06:54 +0200
      Re: help aurora baccio <aurorabaccio@gmail.com> - 2021-06-15 12:06 -0700
        Re: help JohnMartens <martens@tennishulp.info> - 2021-06-15 22:03 +0200
        Re: help "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-06-16 09:08 +0200

#13326 — help

Fromaurora baccio <aurorabaccio@gmail.com>
Date2021-06-12 23:38 -0700
Subjecthelp
Message-ID<4c7b6927-d9f3-45ec-8421-20f57891c17dn@googlegroups.com>
Good morning and good Sunday
I cannot close an archive (ProvPres.dbf) .
For other archives I use :
oInError := InError{,false}
.......
oInError:Close()

end of the procedure

oIrror := InError{,false}
oInError:Zap()
oInError:Close()

The Archive that I can't close feeds a subdatawindow contained in a datadialog and all the data that the user has to check arrives. If everything is correct it proceeds and then :
oProvPres{}:Close()
.........
.ProvPres := oProvPres{,false}
oProvPres:Zap()
oProvPres:Close()

self:Destroy()
I restart the activity assuming that the ProvPres.dbf archive has been reset.
I notice that this procedure does not work, the archive remains open with the data of the previous operation.
I ask for help.
Thanks
Aurora Baccio

[toc] | [next] | [standalone]


#13327

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2021-06-15 06:54 +0200
Message-ID<iiqq42F4kpbU1@mid.individual.net>
In reply to#13326
Buon giorno Aurora,

AFAIK you need to open a DBF in exclusive mode do execute the Zap()
method.
I suspect that there is another instance open that does not permit to
execute thzap operation.

You should make sure that the SubDataWindow is closed and cleaned up.
More than using a :Destroy() call on it I would null it out and issue a
CollectForced() call.

Wolfgang


aurora baccio wrote:

> Good morning and good Sunday
> I cannot close an archive (ProvPres.dbf) .
> For other archives I use :
> oInError := InError{,false}
> .......
> oInError:Close()
> 
> end of the procedure
> 
> oIrror := InError{,false}
> oInError:Zap()
> oInError:Close()
> 
> The Archive that I can't close feeds a subdatawindow contained in a
> datadialog and all the data that the user has to check arrives. If
> everything is correct it proceeds and then :  oProvPres{}:Close()
> .........  .ProvPres := oProvPres{,false}
> oProvPres:Zap()
> oProvPres:Close()
> 
> self:Destroy()
> I restart the activity assuming that the ProvPres.dbf archive has
> been reset.  I notice that this procedure does not work, the archive
> remains open with the data of the previous operation.  I ask for help.
> Thanks
> Aurora Baccio



-- 

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


#13328

Fromaurora baccio <aurorabaccio@gmail.com>
Date2021-06-15 12:06 -0700
Message-ID<786e0eff-66b2-4531-9aff-01e5e16c7183n@googlegroups.com>
In reply to#13327
Il giorno martedì 15 giugno 2021 alle 06:54:27 UTC+2 Wolfgang Riedmann ha scritto:
> Buon giorno Aurora, 
> 
> AFAIK you need to open a DBF in exclusive mode do execute the Zap() 
> method. 
> I suspect that there is another instance open that does not permit to 
> execute thzap operation. 
> 
> You should make sure that the SubDataWindow is closed and cleaned up. 
> More than using a :Destroy() call on it I would null it out and issue a 
> CollectForced() call. 
> 
> Wolfgang
> aurora baccio wrote: 
> 
> > Good morning and good Sunday 
> > I cannot close an archive (ProvPres.dbf) . 
> > For other archives I use : 
> > oInError := InError{,false} 
> > ....... 
> > oInError:Close() 
> > 
> > end of the procedure 
> > 
> > oIrror := InError{,false} 
> > oInError:Zap() 
> > oInError:Close() 
> > 
> > The Archive that I can't close feeds a subdatawindow contained in a 
> > datadialog and all the data that the user has to check arrives. If 
> > everything is correct it proceeds and then : oProvPres{}:Close() 
> > ......... .ProvPres := oProvPres{,false} 
> > oProvPres:Zap() 
> > oProvPres:Close() 
> > 
> > self:Destroy() 
> > I restart the activity assuming that the ProvPres.dbf archive has 
> > been reset. I notice that this procedure does not work, the archive 
> > remains open with the data of the previous operation. I ask for help. 
> > Thanks 
> > Aurora Baccio
> --

Good evening Mr. Riedman and welcome back.
I am reasonably sure that the sub date is closed.
At the end of the procedure I close with oProvPres:Close() the archive in question.
After several attempts I inserted a close databases
I didn't understand why, since all the archives had to be closed but since then the archive zap works.
To be sure of what I do:
oProvPres := ProvPres{,false}
oProvPres:Zap()
oProvPres:Close()
 from here on starts the whole procedure of building the recipe delivery.
When the recipe is registered and archived

I close the datadialog
self:Destroy()

I close the archive.

oProvPres:Close()
close databases
CollectForced()

From what I understand you suggest not to use destroy().
How do I use collectForced ?
Exactly I read that collectforced() skips the garbage collection but honestly I still don't understand why it didn't work before and now it does.
I know one of the rules of computer science is to never ask why, but I remain curious.
thanks
Aurora Baccio


Translated with www.DeepL.com/Translator (free version)

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


#13329

FromJohnMartens <martens@tennishulp.info>
Date2021-06-15 22:03 +0200
Message-ID<sab12b$jl2$1@dont-email.me>
In reply to#13328
Hi Aurora,

Several comments on your issue.

Zap only works if the DBF is only used in exclusive mode that should be 
set bij SetExclusive(TRUE). It should not be open in other parts of your 
app. I think the DBF was open in parts of your app that you are not 
aware of and therefore you cannot zap it.

You can use this code to see what DBF's are open

cMsg := ''
FOR wAlias := 1 UPTO 1024
   cAlias := ALIAS(wAlias)
   IF .NOT. ( cAlias == NULL_STRING )
     dwMethresult += 1
     cMsg += NTrim(wAlias)+' workarea<.>'
     cMsg += '<9>Alias<9><9>'+cAlias+'<.>'
     cMsg += '<9>File name<9><9>'+ (cAlias)->(DBINFO(DBI_FULLPATH))+'<.>'
     cMsg += '<9>Locked records<9>'+ 
NTrim((cAlias)->(DBINFO(DBI_LOCKCOUNT)))+'<.>'
   ENDIF
NEXT

Put the code in a funtion that you call when debugging your app to see 
what DBF's are open en check wether these are the ones that you expect 
to be open.
I'm sure that somewhere you did not close a DBF and thyerefore you 
cannot ZAP it

I'm having a DBF where lots of changes take place. To prvent the DBF 
growing by adding records and deleting them without being able to ZAP 
it. I'm using special delete and apend methods of the DBF

METHOD DeleteToReuse() CLASS MySpecialDbf
	lResult := SUPER:Delete()
	IF lResult
		SELF:Filed1 := ""
		SELF:Field2 := ""
	ENDIF
RETURN lResult

When appending

METHOD AppendReuse() CLASS MySpecialDbf
	LOCAL lMethResult AS LOGIC
	LOCAL lDeleted AS LOGIC
	LOCAL dwRecNr := 0 AS DWORD

	lDeleted := SetDeleted()
	SetDeleted(FALSE)

	DO CASE
	CASE ! SELF:Seek(Space(10))   // Seek on first empty field that can 
only be empty when deleted
	CASE ! SELF:Recall()
		* Message that deleted record cannot be recalled
	OTHERWISE
		dwRecNr := SELF:RecNo
		lMethResult := TRUE
	ENDCASE

	SetDeleted(lDeleted)

	IF dwRecNr = 0
		* no old record found that could be recalled
		lMethResult := SUPER:Append()
	ELSE
		* empty record recalled
		SELF:GoTo(dwRecNr)
	ENDIF
RETURN lMethResult

In this way your DBF will not be for ever growing and there is no need 
to have a EXCLUSIVE access to the DBF

CollectForced() is normaly not needed unless you do not clean all memory 
by ending resources.

When debugging I put this in my shellwindow
METHOD Timer() CLASS MyShellWindow
SELF:StatusBar:SetText(NTrim(Memory(MEMORY_REGISTERAXIT)),#MemoryAxit)
RETURN NIL
If the memory keeps on growing then you hev and issue with nog ending 
windows of window parameters neatly.
I you close it down in the right way there is no need to use Destroy()

Hope this can help you

Cheers,
John


Op 15-6-2021 om 21:06 schreef aurora baccio:
> Il giorno martedì 15 giugno 2021 alle 06:54:27 UTC+2 Wolfgang Riedmann ha scritto:
>> Buon giorno Aurora,
>>
>> AFAIK you need to open a DBF in exclusive mode do execute the Zap()
>> method.
>> I suspect that there is another instance open that does not permit to
>> execute thzap operation.
>>
>> You should make sure that the SubDataWindow is closed and cleaned up.
>> More than using a :Destroy() call on it I would null it out and issue a
>> CollectForced() call.
>>
>> Wolfgang
>> aurora baccio wrote:
>>
>>> Good morning and good Sunday
>>> I cannot close an archive (ProvPres.dbf) .
>>> For other archives I use :
>>> oInError := InError{,false}
>>> .......
>>> oInError:Close()
>>>
>>> end of the procedure
>>>
>>> oIrror := InError{,false}
>>> oInError:Zap()
>>> oInError:Close()
>>>
>>> The Archive that I can't close feeds a subdatawindow contained in a
>>> datadialog and all the data that the user has to check arrives. If
>>> everything is correct it proceeds and then : oProvPres{}:Close()
>>> ......... .ProvPres := oProvPres{,false}
>>> oProvPres:Zap()
>>> oProvPres:Close()
>>>
>>> self:Destroy()
>>> I restart the activity assuming that the ProvPres.dbf archive has
>>> been reset. I notice that this procedure does not work, the archive
>>> remains open with the data of the previous operation. I ask for help.
>>> Thanks
>>> Aurora Baccio
>> --
> 
> Good evening Mr. Riedman and welcome back.
> I am reasonably sure that the sub date is closed.
> At the end of the procedure I close with oProvPres:Close() the archive in question.
> After several attempts I inserted a close databases
> I didn't understand why, since all the archives had to be closed but since then the archive zap works.
> To be sure of what I do:
> oProvPres := ProvPres{,false}
> oProvPres:Zap()
> oProvPres:Close()
>   from here on starts the whole procedure of building the recipe delivery.
> When the recipe is registered and archived
> 
> I close the datadialog
> self:Destroy()
> 
> I close the archive.
> 
> oProvPres:Close()
> close databases
> CollectForced()
> 
>  From what I understand you suggest not to use destroy().
> How do I use collectForced ?
> Exactly I read that collectforced() skips the garbage collection but honestly I still don't understand why it didn't work before and now it does.
> I know one of the rules of computer science is to never ask why, but I remain curious.
> thanks
> Aurora Baccio
> 
> 
> Translated with www.DeepL.com/Translator (free version)
> 

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


#13330

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2021-06-16 09:08 +0200
Message-ID<iitmbeFlndnU1@mid.individual.net>
In reply to#13328
Buon giorno Aurora,

the Destroy() method only cleans up ressources used by the window.
Therefore the DBF used by the subdatawindow may not be closed when the
Destroy() method of the owning DataDialog is called.

CollectForced() triggers a call of the garbage collector, and this call
cleans up all unused ressources, regardless where in the program they
were used.

The garbage collector in the VO runtime is a complicated but very
important piece of software, and for some more advanced tasks it is
important to understand how it works. I also had examples where a
CollectForced() call leaded to GPFs in the program, but that was always
the programmers ( = my ) fault.

Wolfgang


aurora baccio wrote:

> Il giorno martedì 15 giugno 2021 alle 06:54:27 UTC+2 Wolfgang
> Riedmann ha scritto:
> > Buon giorno Aurora, 
> > 
> > AFAIK you need to open a DBF in exclusive mode do execute the Zap() 
> > method. 
> > I suspect that there is another instance open that does not permit
> > to execute thzap operation. 
> > 
> > You should make sure that the SubDataWindow is closed and cleaned
> > up.  More than using a :Destroy() call on it I would null it out
> > and issue a CollectForced() call. 
> > 
> > Wolfgang
> > aurora baccio wrote: 
> > 
> > > Good morning and good Sunday 
> > > I cannot close an archive (ProvPres.dbf) . 
> > > For other archives I use : 
> > > oInError := InError{,false} 
> > > ....... 
> > > oInError:Close() 
> > > 
> > > end of the procedure 
> > > 
> > > oIrror := InError{,false} 
> > > oInError:Zap() 
> > > oInError:Close() 
> > > 
> > > The Archive that I can't close feeds a subdatawindow contained in
> > > a datadialog and all the data that the user has to check arrives.
> > > If everything is correct it proceeds and then :
> > > oProvPres{}:Close() ......... .ProvPres := oProvPres{,false} 
> > > oProvPres:Zap() 
> > > oProvPres:Close() 
> > > 
> > > self:Destroy() 
> > > I restart the activity assuming that the ProvPres.dbf archive has 
> > > been reset. I notice that this procedure does not work, the
> > > archive remains open with the data of the previous operation. I
> > > ask for help.  Thanks 
> > > Aurora Baccio
> > --
> 
> Good evening Mr. Riedman and welcome back.
> I am reasonably sure that the sub date is closed.
> At the end of the procedure I close with oProvPres:Close() the
> archive in question.  After several attempts I inserted a close
> databases I didn't understand why, since all the archives had to be
> closed but since then the archive zap works.  To be sure of what I do:
> oProvPres := ProvPres{,false}
> oProvPres:Zap()
> oProvPres:Close()
>  from here on starts the whole procedure of building the recipe
> delivery.  When the recipe is registered and archived
> 
> I close the datadialog
> self:Destroy()
> 
> I close the archive.
> 
> oProvPres:Close()
> close databases
> CollectForced()
> 
> From what I understand you suggest not to use destroy().
> How do I use collectForced ?
> Exactly I read that collectforced() skips the garbage collection but
> honestly I still don't understand why it didn't work before and now
> it does.  I know one of the rules of computer science is to never ask
> why, but I remain curious.  thanks Aurora Baccio
> 
> 
> Translated with www.DeepL.com/Translator (free version)



-- 

[toc] | [prev] | [standalone]


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


csiph-web