Subject | Re: [IBO] What component? |
---|---|
Author | Dmitry Beloshistov |
Post date | 2004-05-19T13:17:36Z |
Hello, Rafael!
You wrote to <IBObjects@yahoogroups.com> on Wed, 19 May 2004 09:48:35 -0300:
RC> Can you explain how to use Set Term end end^? I saw that you donĀ“t
RC> close the last setterm ... why?
In most cases in script included many statements (procedures, triggers etc.)
and
SET TERM used for switching between statements because ';' in IB/FB is
statement delimiter and
also used in stored procedure and trigger definition.
Example:
set term ^;
create procedire MyProc
returns (CurDate date)
as
begin
CurDate=CURRENT_DATE;
end^
set term ;^
create generator My_Gen;
set generator My_Gen to 0;
But if you have in script only ONE statement - finall "set term" not
required.
WBR, Dmitry Beloshistov AKA [-=BDS=-]
You wrote to <IBObjects@yahoogroups.com> on Wed, 19 May 2004 09:48:35 -0300:
RC> Can you explain how to use Set Term end end^? I saw that you donĀ“t
RC> close the last setterm ... why?
In most cases in script included many statements (procedures, triggers etc.)
and
SET TERM used for switching between statements because ';' in IB/FB is
statement delimiter and
also used in stored procedure and trigger definition.
Example:
set term ^;
create procedire MyProc
returns (CurDate date)
as
begin
CurDate=CURRENT_DATE;
end^
set term ;^
create generator My_Gen;
set generator My_Gen to 0;
But if you have in script only ONE statement - finall "set term" not
required.
WBR, Dmitry Beloshistov AKA [-=BDS=-]