Oninit cdi / Archive
Talk to an expert →

Can form do edit check on Date field.

Posted in 2003

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

Wang, Mike PEO EIS TIS — — source: Usenet: comp.databases.informix

Hi:Everyone Can form do edit check on date field. for example must greater "01/01/2000" in the form when user enter "01010200" it will not accept as "01/01/0200" Or I can only add edit check in 4gl. Thanks Mike Wang

↪ replying to Wang, Mike PEO EIS TIS
Jonathan Leffler — — source: Usenet: comp.databases.informix

Wang, Mike PEO EIS TIS wrote: > Can form do edit check on date field. for example must greater "01/01/2000" > in the form when user enter "01010200" it will not accept as "01/01/0200" > > Or I can only add edit check in 4gl. f000 = sometable.datefield, INCLUDE = ("2000-01-01" TO "2199-12-31"); Choose your range thoughtfully... -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to Wang, Mike PEO EIS TIS
Jonathan Leffler — — source: Usenet: comp.databases.informix

Wang, Mike PEO EIS TIS wrote: > Can form do edit check on date field. for example must greater "01/01/2000" > in the form when user enter "01010200" it will not accept as "01/01/0200" > > Or I can only add edit check in 4gl. I mentioned: ... INCLUDE = ("2000-01-01" TO "2199-12-31"); I didn't mention: And don't forget to worry about the setting of DBDATE... -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Glossary