selwyn-problem with .mpx files

[crimmelcp]

I am having trouble with query files .mpx not deleting.
I have the box checked in the settings, but it doesent seem to work.
causing some problesm in running queries.
I deleted over 500 mpx files today.
any ideas on how to fix.
TKS
Charlie Crimmel

[Steve Workings]

RE: selwyn-problem with .mpx files

Hi Charlie --

That checkbox is a relatively new feature in A5 -- it only came about in a later build.

You can put some stuff in your autoexec script or other startup scripting that deletes the mpx files. I think I cribbed this from someone else (Probably Peter or Finian) but I don't know for sure:

' -----------
Path = :A5.Get_Exe_Path()

filename=path+"$$*.*"

result=file.exists(filename)

if result=.F. then
goto cleanup
end if

files = filefind.first(path+"$$*.*")

WHILE .not. files.eof()
index_name = files.name()
file.remove(index_name)
files.next()
END WHILE

[drgarytraub]

RE: selwyn-problem with .mpx files

Charlie:

I encountered the same problem. Use the following script that executes when user exist your application:

OPTION STRICT

dim path as c

path="C:Program Filesa5v4"

if path = ""

end

end if

dim dir as L

dim result as L

dim response as n

dim files as p

dim filename as c

dim index_name as c

files = filefind.first(path)

dir=files.is_directory()

if dir =.F.

'ui_msg_box("Invalid Directory Path", "Entered. Please try again.")

end

end if

filename=path+"$$*.*"

result=file.exists(filename)

if result=.F. then

end

end if

files = filefind.first(path+"$$*.*")

WHILE .not. files.eof()

index_name = files.name()

file.remove(index_name)

files.next()

END WHILE

end


By executing this script when exiting the app, the mpx files are always deleted. (This script was adapted from one by Finnian Lennon).

Hope it helps


Gary Traub

[CALocklin]

RE: selwyn-problem with .mpx files

Interesting, Steve. I didn't know that File.exists() would work with wild cards. I just checked it out and it works!

There is one minor error in your script. (I'm guessing you missed it doing a "cut and paste".) There is no "Cleanup:" label. As the script is shown, that IF statement could just be:

IF result=.F.
END
END IF

[vasant panjabi]

RE: selwyn-problem with .mpx files

to achieve this with xbasic is too complicated for me.

i revert to good old dos batch file "delmpx.bat" with icon on my desktop which click once a week & it does the job.

del c:a5v4*.mpx
del c:a5v4a5data*.mpx

i wonder if add the bat file to windows startup - will that work.
have not tried it.

v.p

[Stan Mathews]

RE: selwyn-problem with .mpx files

Vasant,

Yes, that should work, too.

PS If you want to type in path names use the
ampersandnumbersign92semicolon in place of the backslash.
You only need type it once and then cut ane paste each occurrence.

c:\program files\A5v4\filename

Now I'll try to make the "code" appear.

c:\program files\A5v4\filename

Here's hoping.

Stan

[Stan Mathews]

RE: selwyn-problem with .mpx files

Trying again

c:&amp#92;program files&amp#92;A5v4&amp#92;filename