On 08/26/2015 05:02 PM, Jiří Činčura wrote:
> Hi *,
>
> I'm looking at DNET-313 and the code get from server "subscript out of
> bounds". Can somebody tell me what that means? I have never used (and will
> never use ;)) arrays, so this is new to me.
>
Jiri, rather hard to explain text which is so clear to me. Look at
employee database:
# isql employee
SQL> show table JOB;
JOB_CODE (JOBCODE) VARCHAR(5) Not Null
CHECK (VALUE > '99999')
JOB_GRADE (JOBGRADE) SMALLINT Not Null
CHECK (VALUE BETWEEN 0 AND 6)
JOB_COUNTRY (COUNTRYNAME) VARCHAR(15) Not Null
JOB_TITLE VARCHAR(25) Not Null
MIN_SALARY (SALARY) NUMERIC(10, 2) Not Null DEFAULT 0
CHECK (VALUE > 0)
MAX_SALARY (SALARY) NUMERIC(10, 2) Not Null DEFAULT 0
CHECK (VALUE > 0)
JOB_REQUIREMENT BLOB segment 400, subtype TEXT Nullable
LANGUAGE_REQ ARRAY OF [5]
VARCHAR(15) Nullable
SQL> select LANGUAGE_REQ[2] from JOB where LANGUAGE_REQ is not null;
LANGUAGE_REQ
===============
Mandarin
German
German
Spanish
German
French
French
English
German
French
SQL> select LANGUAGE_REQ[0] from JOB where LANGUAGE_REQ is not null;
LANGUAGE_REQ
===============
Statement failed, SQLSTATE = 42000
subscript out of bounds
SQL> select LANGUAGE_REQ[6] from JOB where LANGUAGE_REQ is not null;
LANGUAGE_REQ
===============
Statement failed, SQLSTATE = 42000
subscript out of bounds
---------------------------------------------------
I.e. you get this error when try to use subscript which is out of bounds
for an array.
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
