Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #13329
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: help |
| Date | 2021-06-15 22:03 +0200 |
| Organization | A noiseless patient Spider |
| Message-ID | <sab12b$jl2$1@dont-email.me> (permalink) |
| References | <4c7b6927-d9f3-45ec-8421-20f57891c17dn@googlegroups.com> <iiqq42F4kpbU1@mid.individual.net> <786e0eff-66b2-4531-9aff-01e5e16c7183n@googlegroups.com> |
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)
>
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
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
csiph-web