----- Original Message -----
From: Ann Harrison <harrison@...>
To: <IB-Conversions@egroups.com>; <IB-Conversions@egroups.com>
Sent: Sexta-feira, 27 de Outubro de 2000 15:11
Subject: Re: [IB-Conversions] A Question about how I can convert syntax
Sybase to Interbase


At 02:53 PM 10/27/2000 -0200, Marcos Fabiano Mendes de Siqueira wrote:
>Hello!
>
>What´s a syntax for stored procedure?


In ISQL the syntax for defining a procedure is this:

set term !!;
create procedure <whatever> [(input params)]
[returns (output params)]
as
[variable declarations]
begin
statement;
[statement; ...]
end!!

set term;!!

What are those silly double bangs? The ISQL parser
is unable to distinguish between the semi-colon that
terminates a statement in a procedure declaration and
the one that ends the declaration itself. Set term
tells it to use a different terminator for statements
to be executed by ISQL. The set term statement is
terminated by a semi-colon, of course. Once the
procedure declaration has been made, set term switches
back to a semi-colon terminator - and that statement
is terminated with !!.

Regards,

Ann



To unsubscribe from this group, send an email to:
IB-Conversions-unsubscribe@egroups.com