开发者

Executing a script using ISQL

开发者 https://www.devze.com 2023-03-01 03:40 出处:网络
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'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';
0

精彩评论

暂无评论...
验证码 换一张
取 消