Subject | Declaring arrays |
---|---|
Author | Sergio |
Post date | 2006-04-10T22:57:08Z |
Hi all.
I posted this message a few days ago and I didn't receive jet any solution.
Can somebody help me? I need to declare an array in a procedure, and I don't
know if that is possible in FB. I used this syntax:
SET TERM!!;
CREATE PROCEDURE MyProcedure (Param1 VARCHAR(5))
AS
DECLARE VARIABLE anyname INTEGER[5]; /* Array of five integer
numbers */
BEGIN
/* Procedure Text */
END!!
SET TERM;!!
COMMIT WORK;
Is that correct? Or this feature is not implemented? I'm using FB 1.5.2, and
when I try to compile the procedure I receive the message:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 5, char 34 [
Regards
Sergio
PD: Sorry my english...
I posted this message a few days ago and I didn't receive jet any solution.
Can somebody help me? I need to declare an array in a procedure, and I don't
know if that is possible in FB. I used this syntax:
SET TERM!!;
CREATE PROCEDURE MyProcedure (Param1 VARCHAR(5))
AS
DECLARE VARIABLE anyname INTEGER[5]; /* Array of five integer
numbers */
BEGIN
/* Procedure Text */
END!!
SET TERM;!!
COMMIT WORK;
Is that correct? Or this feature is not implemented? I'm using FB 1.5.2, and
when I try to compile the procedure I receive the message:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 5, char 34 [
Regards
Sergio
PD: Sorry my english...