2 replies to this topic

[sarahim]

Hi,

I want some help:

if i run the below script at the following line:

if( LaunchAppAndWait(TARGETDIR^"bin\\start.exe", "-c dbcheck", WAIT) < 0) then

The behavior here is , it is taking some extra time ,delay during Patch installation and de-installation on WinNT platform, it pop-ups windows, which automatically goes-off .
how to reduce the delay??


###########
function JJJ_01065_PostDeInstall()

STRING strSRCDIR;
STRING strTARGET;
STRING strSQL;
STRING strCmd;
NUMBER fd;
LONG retVal;

begin
strSRCDIR = SRCDIR;
strTARGET = TARGETDIR;

if( LaunchAppAndWait(TARGETDIR^"bin\\start.exe", "-c dbcheck", WAIT) < 0) then
MessageBox("Could not run start.exe from " + TARGETDIR + "Please run it manually after the patch installation", WARNING);
endif;

OpenFileMode(FILE_MODE_APPEND);
CreateFile(fd,TARGETDIR^"bin","deSQL.txt");
WriteLine(fd,"alter table NWInterface_1 drop column lastpolledtime; alter table NWInterface_2 drop column lastpolledtime;;");

strSQL = TARGETDIR^"bin\\deSQL.txt";
strCmd = " -file " + strSQL + " -force";
if( LaunchAppAndWait(TARGETDIR^"bin\\dwquery.exe",strCmd,WAIT) < 0) then
MessageBox("Could not start dwquery.exe from " + TARGETDIR + "with command line options" + strCmd + " Please run manually after the patch installation", WARNING);
endif;

if( LaunchAppAndWait(TARGETDIR^"bin\\stop.exe","", WAIT) < 0) then
MessageBox("Could not run stop.exe from " + TARGETDIR + "Please run it manually after the patch insta llation", WARNING);
endif;

TARGETDIR = strTARGET;
TARGETDIR = TARGETDIR^"bin";
DeleteFile("deSQL.txt");

SRCDIR = strSRCDIR;
TARGETDIR = strTARGET;

end;

[Stefan Krueger]

I guess it depends on what your start.exe is doing.

[Perotin]

it seems, you are running a database patch, so if you complain about the time between the popup of the "start database" program and the time you get the return value of LaunchAppAndWait, ask the vendor of the database system.

btw: when you want the user to run the query command after failure of the procedure, it is not helpful to delete the file with the db-commands ...