logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

maintenance
W5GA
#1 Posted : Thursday, September 18, 2025 10:34:36 AM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 442
Location: Missouri

Thanks: 87 times
Was thanked: 143 time(s) in 128 post(s)
Dennis, does performing a "clean" do more than performing the reindex shown on tools/database maintenance?
73 Doug W5GA
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
WN4AZY
#2 Posted : Thursday, September 25, 2025 9:00:37 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,169
Man
Location: Auburn, GA

Thanks: 1067 times
Was thanked: 518 time(s) in 432 post(s)
Yes, it does more. It deletes some temporary files, for instance.

Here is the code FYI:

Delete File *.Cdx
Delete File *.tbk
Delete File *.bak

Delete File (Addbs(.datadir)+"*.CDX")
Delete File (Addbs(.datadir)+"*.TBK")
Delete File (Addbs(.datadir)+"*.BAK")
Delete File (Addbs(.datadir)+"*.TMP") && DH 8/17/21 10.0.1

* delete stuff in TMP subdir
* Can't just DELETE FILE TMP\*.* because there are some that
* are in use whenever foxpro is running.

Cnt = Adir(farr, "TMP\*.*")

On Error *
For i = 1 To Cnt
Delete File ("tmp\"+farr[i,1]) recycle
Endfor
On Error

Note that instead of reindexing, it deletes the index files, forcing a reindex when LOGic restarts and sees they are missing. Kind of like a new install.

Let me know if any other questions.

Tnx/73,

WN4AZY
1 user thanked WN4AZY for this useful post.
W5GA on 9/25/2025(UTC)
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.030 seconds.