|
Hi, when you create a field type L on a database and you import his description to SDA (f10), you will have a field type B(10). If you want to have a special value on a database when you do a cpyf this field on the database most have the DFT() keyword on it. The default is sysdate. Emilio Padilla -----Original Message----- From: Alison Herman <alison@gmdsolutions.com> To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com> Date: Thursday, March 11, 1999 1:49 PM Subject: ISO Dates >Hello to all! > >I have looked thru the archives and could not find an answer so thought >I would just ask. > >We have decided on all new developement to use ISO dates. The >programmer who is working on the first implementation of this has ran >into some problems. It is his contention that: > >1. If you define a date with type L on the screen. This field may not >be left blank and the users must enter 0001-01-01. > >2. Doing a cpyf if the field is blank, it is initialized to the current >date. > >3. We will need to define dates on the screen a 8,0 and within the >program do the date validation manually and handle 0 and 0001-01-01. > >I guess if #3 is the way we need to go it will only take a couple of >moves, a couple of ifs, and a test statement. Are there any other >suggestions of how this is being handled. > >Thanks in advance. > >Alison Herman >+--- >| This is the Midrange System Mailing List! >| To submit a new message, send your mail to MIDRANGE-L@midrange.com. >| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. >| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. >| Questions should be directed to the list owner/operator: david@midrange.com >+--- > +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.