Hi,
I have a problem with a temp-table that (simplified) looks like this:
DEF TEMP-TABLE products
FIELD name AS CHAR
FIELD price AS INT EXTENT 10 INITIAL 0
INDEX idxname name
INDEX idxprice price.
There's not always a price in all of the 10 extents, so it might sometimes be 0.
When I do "CREATE products." I get
** Array subscript 0 is out of range. (26)
If I take away the idxprice index everything works, I also tried INDEX idxprice price[1], but that doesn't compile.
Any hints anyone?
Using 8.2B on Solaris 2.5
Regards
Jens
I have a problem with a temp-table that (simplified) looks like this:
DEF TEMP-TABLE products
FIELD name AS CHAR
FIELD price AS INT EXTENT 10 INITIAL 0
INDEX idxname name
INDEX idxprice price.
There's not always a price in all of the 10 extents, so it might sometimes be 0.
When I do "CREATE products." I get
** Array subscript 0 is out of range. (26)
If I take away the idxprice index everything works, I also tried INDEX idxprice price[1], but that doesn't compile.
Any hints anyone?
Using 8.2B on Solaris 2.5
Regards
Jens