I'm trying to use a batch file combined with Windows task scheduler to manipulate the values of a firebird database table on a certain date and time. Since Windows task scheduler already has most of this capability, it only makes sense to use it.
So from the command prompt I browse to the firebird/bin folder and execute isql
.
Then I connect using the following:
CONNECT 'localhost:C:\Program Files\database\dbserver.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
Connect seems to work ok.
Then I try a standard update statement and it doesn't work, however, if I use IBEXPERT which is a GUI based database browsing tool the SQL works.
Whats wrong with my statement and why can't isql execute it?
update globalsettings set keyvalue=0 where keyvalue=1 and keyname='ENABLE PRICE SHIFT';