This is a multi-part message in MIME format.
------=_NextPart_000_000C_01BE9ADA.E9559280
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am working in a project for Year 2000 compliance and I was asked to =
force the users to enter a 4 digit year using Informix 4gl software. I =
am using 'format' and 'picture' but I have not been able to do it. Is =
there a way to do it? How can it be done?
I would appreciate any advise.
Thank you,
Ivan A. Ramirez (10700)
------=_NextPart_000_000C_01BE9ADA.E9559280
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#d8d0c8>
<DIV>I am working in a project for Year 2000 compliance and I was asked =
to force=20
the users to enter a 4 digit year using Informix 4gl software. I =
am using=20
'format' and 'picture' but I have not been able to do it. Is there =
a way=20
to do it? How can it be done?</FONT><BR><FONT =
size=3D3><BR></FONT><FONT=20
size=3D2>I would appreciate any advise.</FONT><BR><FONT =
size=3D3><BR></FONT><FONT=20
size=3D2>Thank you,</FONT><BR><FONT size=3D2>Ivan A. Ramirez=20
(10700)</FONT><BR></DIV></BODY></HTML>
------=_NextPart_000_000C_01BE9ADA.E9559280--
↪ replying to T.A.P.S.
T.A.P.S. wrote:
> I am working in a project for Year 2000 compliance and I was asked
> to force the users to enter a 4 digit year using Informix 4gl
> software. I am using 'format' and 'picture' but I have not been
> able to do it. Is there a way to do it? How can it be done?
Succinctly, for most purposes, the answer is no.
If you are really desparate, use PICTURE="####-##-##" and
FORMAT = "YYYY-MM-DD" and enforce DBDATE=Y4MD-. Now the user
cannot get to the MM and DD part without typeing 4 digits in
the year.
Probably, you don't want to force the users to type 4 digits for the
year. You only want the program to display what the user entered with
4 digits for the year, and with sufficient check constraints on the
specific columns to validate that the value is plausible if they
entered 2 digits for the year and I4GL supplied the century.
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN
#include <disclaimer.h>