Re: Informix -1210 error - again !

It most likely is occurring during an insert or update. The error is telling you that you are inserting (or updating) a date field with an integer value, (which is fine, in and of itself), but that in the instance where the error is generated, the integer is out of range (-693,594 to 2,958,464). Check your inserts and updates to find one that is manipulating a date column using an integer variable. There may be other tricks to finding this problem, (such as adding line numbers or cursor descriptions to the errors generated) but I don't know 4gl well enough to be much help, there. In article <Minx5.1107$Un.2131080@nnrp6.proxad.net>, "Thierry Baribaud" <thierry.baribaud@anstel.com> wrote: > Hi there, > > It is not very fair to delete the message I put here one week ago > without giving me any response. > > My problem was the following : > > Does anyone can tell me how to deal with Informix -1210 error. > > It appears sometimes in my programmes and I cannot find how and > where it occurs. > > Is there any trick to track this error ? > > I'am using Informix 4GL v6.04.UC1 with Informix SE v7.22.UC2 on > a SGI Origin200 server (os IRIX 6.5). > > Thank you by advance > > Best regards > > T. Baribaud > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.