I'm creating a simple isq开发者_开发技巧l script but it's not working and I need some help to find out whats wrong with it.
I need to connect to a database and execute a SQL file. This is my script called script.sql:CONNECT 'localhost:C:\Monde\Servidor\db\monde.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
update usuario
set senha = 'MYkWEn0kHLHHdm'
where login = 'rose'
When I try to connect to my database using.:
isql.exe -i script.sql
I get this follow message.:
Use CONNECT or CREATE DATABASE to specify a database
Expected end of statement, encountered EOF
Ok although it's an old question I found out how to do it, you just need to append de -q parameter, like this:
isql.exe -q -i script.sql
Source:
iSQL Reference form Destructor.de
Append a semicolon to the end of the UPDATE
statement:
CONNECT 'localhost:C:\Monde\Servidor\db\monde.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
update usuario
set senha = 'MYkWEn0kHLHHdm'
where login = 'rose';
精彩评论