FW: Informix record member as array fails compilation

Hi We get the following compiler error when trying to create an Informix table with a member consisting of a 2-dimensional array using 4GL. Is it possible? Here is a copy of my code: create temp table ts_ac_tmp ( date_started date, lane_nr char(4), ts_seq_nr integer, time_started integer, audit_count array[7,14] of integer) |__________________________^ | | A grammatical error has been found on line 38, character 28. | The construct is not understandable in its context. | See error number -4373. |__________________________^ | | A grammatical error has been found on line 38, character 28. | The construct is not understandable in its context. | See error number -4373. According to Ch 35 of "Informix Unleashed", quoted below, this should be possible. "INFORMIX-4GL allows you to define two exceptionally powerful data structures: the record and the array. The record data type is a collection of members in which each member can have any valid Informix data type (either a simple data type, another record, or an array). The array is a data structure of up to three dimensions of values of the same data type;" Regards David

a datastucture != a table. so it is not possible. Superboer. On 19 jan, 14:15, "David Reed" <David.R...@tollink.co.za> wrote: > Hi > > We get the following compiler error when trying to create an Informix > table with a member consisting of a 2-dimensional array using 4GL. Is it > possible? Here is a copy of my code: > >    create temp table ts_ac_tmp (> >      date_started     date, > >      lane_nr          char(4), > >      ts_seq_nr        integer, > >      time_started     integer, > >      audit_count      array[7,14] of integer) > > |__________________________^ > > | > > |      A grammatical error has been found on line 38, character 28. > > | The construct is not understandable in its context. > > | See error number -4373. > > |__________________________^ > > | > > |      A grammatical error has been found on line 38, character 28. > > | The construct is not understandable in its context. > > | See error number -4373. > > According to Ch 35 of "Informix Unleashed", quoted below, this should be > possible. > > "INFORMIX-4GL allows you to define two exceptionally powerful data > structures: the record and the array. The record data type is a > collection of members in which each member can have any valid Informix > data type (either a simple data type, another record, or an array). The > array is a data structure of up to three dimensions of values of the > same data type;" > > Regards > > David