Re: Oracle Forms 4.5 - Help!!!

faisalr_at_swbell.net wrote:
>
> I need answers to the following questions (for an assignment
> ...please)
>
> A) In a library management system different books are issued to the
> members and certain books are returned by the members. The system is
> developed in forms 4.5. Presently, there is no validation for issue
> date and return date. Need to write VALIDATION CODE. If the return date is
> smaller than the issue date a message should be displayed indicating
> the error before going to the next record. Need a sample validation code
> and the NAME of the TRIGGER used.

Look at the help for WHEN-VALIDATE....

> B) A goods company maintains its inventory system in Oracle Forms. In the
> data entry module, a small window appears if the operator enters the
> wrong code. Recently, a lot of new items have been added with their code.
> You are requested to update the system in such a way that it should take
> care of the item codes as well as well as future expansion. The user of
> the system will be happy if they are allowed to edit the text field in
> Notepad. What will you do to keep the user happy?

Base the data entry validation on a lookup table. The editor envoked when the edit hot-key is pressed (usually CTRL-E) may be set to Notepad.

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||