Re: Oracle Forms and formatting with Display Items

Sounds like you want a non-database field. There is a property to determine if the object is a base table object or not. If marked false, the database is by definition never updated with this information. You can use a post-query trigger on a database block as the point in time when you populate the non-database fields.

Another thing to do is to change the background of the box -- make it the same as the form background and/or remove any borders from the field. Again, it makes the field (which obviously is still there) look less there.

If you want to eventually update the database field -- you can use other triggers (PRE-INSERT, PRE-UPDATE) to retrieve the values from the non-database fields and populate the cooresponding database field. If you do not want the database field to be display -- remove the canvas or mark the field as not displayed.

Mike Krolewski

Kim Simons wrote:

> Ricardo Patrocínio wrote:
> >
> > If You Use a text Item and put the Insert_Allowed, Update_Allowed and
> > Delete_Allowed To False You Will get the same results as if it was an
> > display item (even better, because they stay navigable).
>
> Thanks for responding to my first question. I have tried what you said
> but I don't want the field to be navigable. I don't want to give the
> user the impression that he/she can update it. If you the navigable
> field to False, the user can still use the mouse to click into that
> area. The other problem is that I may need to intercept the values
> coming out of the database and change what is displayed to the user,
> like displaying a "blank" instead of a "0". I think when I tried this I
> got an error because the field could not be updated. Any more
> suggestions? Do you know how to supplement the Select statement to put
> in the function TO_CHAR() to do the formatting but to leave the rest of
> the "Selecting" up to Oracle Forms?
>
> Thanks,
> Kim
Received on Thu May 07 1998 - 08:04:11 CEST