Subject Re: [IB-Architect] Syntax of Declare Variable in storedprocs
Author Ivan Prenosil
> YES to: vardef ::= "declare variable" ident { "," ident } datatype ";".
> as it's rather easy to implement and has low impact, but
>
> NO to: vardef ::= "declare variable" ident [{ "," ident }] domain ";".
> (unless someone *really* sees through all the implications and is
> willing and able to do all the coding & testing :-)

And why _each_ declaration must contain DECLARE VARIABLE at all ?
They are always between AS and BEGIN.

So you could save even more typing (copy-pasting, actually) if instead of current
DECLARE VARIABLE A INTEGER;
DECLARE VARIABLE B INTEGER;
DECLARE VARIABLE C CHAR(1);
DECLARE VARIABLE D CHAR(2);

or proposed
DECLARE VARIABLE A,B INTEGER;
DECLARE VARIABLE C,D CHAR(1);

you use just
CREATE PROCEDURE ... AS
[DECLARE VARIABLES]
A INTEGER;
B INTEGER;
C CHAR(1);
D CHAR(2);
BEGIN ...

or
[DECLARE VARIABLES]
A,B INTEGER;
C,D CHAR(1);


Ivan
http://www.volny.cz/iprenosil/interbase