Re: Forms field formatting question

1/20/99: We tried everything to get the form to accept > and <, but it wouldn't. We even
created a separate field next to the date field that we were browsing. Final solution: instead of > and <, the users will use + and -. These characters work and will be understandable to the user.

In article <77vnq3$t2n$1_at_nnrp1.dejanews.com>,   alan_osur_at_my-dejanews.com wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 20 1999 - 15:23:23 CET