I have a script that used to call a Unix script to convert a file called advise. We are converting from Unix/Oracle to SQLServer2005/Windows2003, so the script has been rewritten in VBScript. How do I execute the script from the Baan Script? The old way was:
spool.fileout="/export/web/paymentadvise/checkfile"&dat
id=brp.open("rtfcmgc41011000","ASCIF",0)
read.main.table()
brp.close(id)
shell "cd /export/web/paymentadvise;./advise;mv "spool.fileout&" /export/web/paymentadvise/archive/checkfile"&dat&" ",1)

I'm not sure how to set this up to execute the vbscript instead of the "advise" unix script

Hi,

As it is written in the manual:
This function (shell) is supported for backward compatibility only. In new applications, use run.prog() and run.baan.prog() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_starting_and_stopping_programs_run_baan_prog_run_prog) instead.
I hope it helps,

- George

can you point me to the correct manual? Although I am continuing to find different manuals as I go. I did not see that in what I have. Run.prog will work for VB? If so, that's great.

I was just told that I cannot use run.prog to run a vbscript. It will only run a .exe or a .bat. Is there anyway to run vbscript from a baan script?

Have you tried to include the call to the vbscript file in a .bat file, like: 'call cscript %DIR%\%FILE%.vbs' ?