Re: Informix 4GL INSERT statement with SERIAL
Use zero, which means "generate the next number" in a serial column:
LET lr_ope.ope_cod = 0
...
Regards,
Doug Lawry
"eferreyra" <eferreyra@gmail.com> wrote in message
news:824385bf-96bd-4006-b8ee-f4a3f9f7678c@x9g2000yqk.googlegroups.com...
> Hi people, i have a "large" table with a SERIAL as pk. In I4GL i have
> a record variable like this table, then i try to use insert statement
> with the record.* but always fail because the pk (serial) is null, how
> can i fix this ?
>
> DEFINE lr_ope RECORD LIKE operaciones.*
> --
>
> LET lr_ope.ope_cod = NULL -- SERIAL FIELD (PK)
> --
>
> INSERT INTO operaciones VALUES (lr_ope.*)
> -- Cannot insert a null into column (operaciones.ope_cod)>
> Thanks !!
>