OK, but how can I know when I have to use Set term?
In query that haves a lot of selects I have to use? Or only in differents
commands?

Rafael

> 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=-]
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>