Re: IUS-SPL: Collections / Foreach Problem
Posted in 1998
Christian Haul — — source: Informix-list mailing list archive (1991-1998)
Christian Haul <haul@informatik.tu-darmstadt.de> wrote: > I thought I did it like it is described in IUS-Guide to SQL: Tutorial > pages 14-43ff. Yet, IUS complains that it needs a cast from integer > to set(integer not null). > It seems that I don't understand the 'select a into set_a' part. > Can anybody help? Found it myself. The column in the example is also of type "set ( integer not null)", I would need to use something like "insert into table ( contents_a) values ((select ....))". (Interestingly enough, I get an "not owner" error if this results in more than one row. Anyway, my problem is solved.) Chris.