Well, you could insert your row and then have a trigger & stored
procedure look at the current date and the one you inserted to determine
if you need to do something like my_date = my_date - 100 UNITS YEAR.
--EEM
-----Original Message-----
From: DYNAMIC INFORMIX [mailto:iffranco@hotmail.com]
Sent: Monday, March 05, 2007 2:22 PM
To: Everett Mills
Subject: Re: RE: How change SO environments by DBACCESS ? []
The following e-mail was sent to you via IDS Forum from DYNAMIC INFORMIX
(iffranco@hotmail.com) at IP address 207.43.195.202
(kcecfp02.sprint.com).
************************************************************************
*******
Re: RE: How change SO environments by DBACCESS ?
Hi.
I need do a insert operation of a DATE field with a 2 algarism year (ex
- 99). To do that, I have to update the DBCENTURY unix environment
variable to Value C (Closest), but I was thinking to make a Procedure in
DBACCESS to do this, because ending the Insert, the DBCENTURY have to
return to previous value : R (current).
I know, it is confuse.
Thanks.
Dynamic
************************************************************************
*******