hi Tore,

thanks so much for the reply.

I have tried it but unfortunately nothing happens.

my original code is (it's working):

lcOldDir=Fullpath(Curdir())

CD "C:\Program Files\MySQL\MySQL Server 5.1\bin\"
RUN mysqldump -umybranch -ppassdes > c:\123\mybackup.sql

cd (lcOldDir)

I changed to:

lcOldDir=Fullpath(Curdir())

#DEFINE SW_HIDE             0
lcDir = "C:\Program Files\MySQL\MySQL Server 5.1\bin\"
lcCmd = lcDir + "mysqldump"
lcPrm = "-umybranch -ppassdes > c:\123\mybackup.sql"
DECLARE Long ShellExecute IN "Shell32.dll" ;
	Long hwnd, String lpVerb, String lpFile, ;
	String lpParameters, String lpDirectory, Long nShowCmd
ShellExecute(0, "", lcCmd, lcPrm, lcDir, SW_HIDE)

cd (lcOldDir)

nothing happens.

am I missing something?

regards,

Jerry