Gust2002
10th September 2006 14:50 UTC

Update database
Hi! I need help!
This is my first NSIS project and I can’t update my FireBird’s database with NSIS. I have the script file (SQL) in the installer package, copy them in some directory and after try to execute some commands with FireBird utilites:
Section "MainSection" SEC01
…
SetOutPath "$EXEDIR\$UPDATE_NAME"
SetOverwrite ifnewer
File "<my temp directory>\Update007.sql"
ExecWait '"$FIREBIRD_DIR_bin\gfix" -shut -force 1 DATABASE_1_5_1.gdb -user SYSDBA -pas masterkey'
…
Other update commands
…
SectionEnd

As result "update commands" don’t work. If turn off "SetOutPath…" string all commands work properly…

kichik
15th September 2006 08:52 UTC

Provide the full path to DATABASE_1_5_1.gdb. Using SetOutPath change the working directory, so the path where this database will be looked for is changed as well. If you provide a full path, it will always look in the correct path.

Gust2002
15th September 2006 12:36 UTC

Thank you very much.