Hi Albert,

You can use API_APPRUN in .VCX form File #9477 or WSH Run method.

oShell = createobject("WScript.Shell")
oShell.Run(lcCmd, 0, .T.)

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/wsmthrun.asp for details.


>
>I have a strange problem with the run command in VFP8.0 SP1
>The /N parameter can't be used with big tables.
>Without /N the run command does not work ??????
>
>I want to sysnc to databases on different servers with the cloadercli.exe tool
>
>l_tabelle = "xyz"
>l_tabellenkey = "xyzid"
>
>*extraxtcommando
>l_loaderoutcmd ="dataextract * from "+l_tabelle+" order by "+l_tabellenkey+" outstream 'out"+l_tabelle+"'"
>IF FILE('loaderoutcmd.txt')
> DELETE FILE 'loaderoutcmd.txt'
>ENDIF
>STRTOFILE(l_loaderoutcmd,'loaderoutcmd.txt')
>*extract with loadercli
>l_befehl = "RUN /N c:\programme\maxdb\7500\bin\loadercli.exe -d BWNEU -u yyy,xxx -n myextractserver -b loaderoutcmd.txt"
>&l_befehl
>
>*loadcommando
>IF FILE('loaderincmd.txt')
> DELETE FILE 'loaderincmd.txt'
>ENDIF
>l_loaderincmd ="delete from "+l_tabelle+" " + CHR(10)+CHR(13)
>l_verbinder = "//" + CHR(10)+CHR(13)
>l_cmd = "dataload TABLE "+l_tabelle+" instream 'out"+l_tabelle+"'"
>STRTOFILE(l_loaderincmd,'loaderincmd.txt')
>STRTOFILE(l_verbinder,'loaderincmd.txt',1)
>STRTOFILE(l_cmd,'loaderincmd.txt',1)
>
>*load
>l_befehl = "RUN /N c:\programme\maxdb\7500\bin\loadercli.exe -d BWNEU -u www,qqq -n myloadserver -b loaderincmd.txt -E 2"
>&l_befehl
>
>
>With small tables everything works as expected ! (the extract is very fast)
>With big tables the load starts before the extract has finished !!! (/N)
>Without the /N parameter the run commands do not work ???????
>
>Any help welcomed
>Best regards
>Albert