I've been using WinRar for a long time to build .exes and send down to laptops for people at work, via a weburl. I'm hoping to replace that process with this to make it a bit more transparent. In my WinRar package, I include osql.exe and updatesql.sql script, as well as the batch file. My batch file simply calls osql and sql script in the same line.
I'm totally confused on how to use the %MYFILES% paramater or if I can for this. I can write my simple little batch file, as I've currently been using it:
Code: Select all
@echo off
echo updating laptop database...
osql -ddatabasename -Uuser -Ppassword -iupdatesql.sql -n
echo.
pause
Code: Select all
@echo off
echo updating laptop database...
CALL %MYFILES%\updatesql.sql
CALL %MYFILES%\osql.exe
osql -ddatabasename -Uuser -Ppassword -iupdatesql.sql -n
echo.
pause
It might not be possible to do this in this way.. but just wanting to make sure it's not something I'm doing wrong before giving up.
Thank you!