Re: Forms field formatting question

[Quoted] Help. Similar problem in Query mode except ours is using date to char and the '>' and '<' characters before the date field. Works fine in 4.5, but not in 5.0. Called Oracle - nothing yet.

Alan

In article <775h0e$etc$1_at_nnrp1.dejanews.com>,   cary_at_nams.net wrote:
> Hello,
>
> I know that I am overlooking something here, but anyway.... Suppose I have
> phone number fields in an Oracle form which correspond to columns in a
> database table of type INTEGER. Now, I want to display these 10-digit
> integers like (999)999-9999, but the format mask FM"("999")"999"-"9999 will
> not work for some reason. (The maximum length attribute has been adjusted
> appropriately.) If I change the mask to FM999"-"999"-"9999, however, it works
> fine and therefore seems to be a problem with having the mask start with an
> embedded character (???). The only solution I could come up with (but do not
> like) is to change the phone numbers to type VARCHAR2, in which case the
> format mask FM"("999")"999"-"9999 works fine. Unfortunately, this causes a
> conflict (I think) with Oracle Reports because this product will not allow a
> format mask with a field of type VARCHAR2 (and I don't think you can change
> the field type). Does anyone have a solution/workaround to this problem?
> Thanks.
>
> Cary
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 18 1999 - 17:34:12 CET