TZSqlProcessor + FB 2.0 Embedded: SET TERM causes an error
Posted: 18.09.2009, 10:59
Hi all,
I have Delphi 2007, Zeos 6.6.5-stable and Firebird 2.0.3 Embedded.
I try to execute a script with TZSqlProcessor, this script creates a procedure in my DB:
And I get the following error:
I have Delphi 2007, Zeos 6.6.5-stable and Firebird 2.0.3 Embedded.
I try to execute a script with TZSqlProcessor, this script creates a procedure in my DB:
Code: Select all
SET TERM ^ ;
CREATE OR ALTER PROCEDURE G5M_WORKPLACE_DEACTIVATE (
p_device_id integer,
p_workplace_num integer)
as
begin
/* Procedure Text */
update g5m_probe
set is_active=0
where device_id=:p_device_id
and workplace_number=:p_workplace_num
and is_active=1;
end;
SET TERM ; ^
GRANT SELECT,UPDATE ON G5M_PROBE TO PROCEDURE G5M_WORKPLACE_DEACTIVATE;
What could I do with this? Thanks in advance.SQL Error: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 5 TERM. Error Code: -104. Invalid token The SQL: SET TERM ^
;