Re: Two Forms Questions

From: Ian Jones <ijones_at_slip.net>
Date: 1998/02/13
Message-ID: <34e3c557.38948738_at_news.slip.net>#1/1


>>
>> 1) I have a date item. The format is DD/MM/YYYY. Is it possible to set
 the item such that
>> the user need only type DDMMYYYY instead of DD/MM/YYYY? (i.e. not need to
 type "/", but the item
>> still show DD/MM/YYYY)
>
>Yes, but it cannot be done through the Format Mask property. To make the
>"/" appear automatically, you have to change the data type property of the
>item from Date to Char (in the form, not the database). Then create a
>When-Validate-Item trigger to insert the "/" after the second and fourth
>characters.
>
Nice idea but be careful doing this. You will have to order the field, validate the field and potentially lose index paths because forms may do TO_CHAR(date_field) = '<char value>' (or you will need to have an order by TO_DATE('char_field') which won't scale.

I believe any character will get replaced by '/' so you could simply type DD MM YY and it will fill in '/' s for you.

If you get a slick work around let me know!

>
>>
>> 2) I heard that Form5.0 has been released. Is that true? In which
 Developer 2000 version?
>> Can Form5.0 run on 16-bit platform (in Windows 3.11)?
>
>Yes, Forms 5.0 is available in Developer 2000 version 2.0. I do not know
>if it will run on a 16-bit platform.

I don't believe that v2 will be available on 16bit.
>
>>
>> Thanks,
>> Jimmy
>>
>
>Hope this helps.
>
>Todd Owers
Received on Fri Feb 13 1998 - 00:00:00 CET

Original text of this message