Re: developer forms

Now it is starting to sound like a homework question...

kushan <vikasmamta_at_my-deja.com> wrote:

>THANKS
>ONE MORE QUES
>
>
>FRM-40505: ORACLE error: unable to perform query
>ORA-00904: invalid column name Using the Runform Help, Display Error
>menu, you have determined that the Key-Exeqry trigger causes the error
>messages shown above. What should you do?
>
>1. Try the query again using different enter_query values in different
>columns.
>
>2. Make sure the table name in the query is correct.
>3.Inspect the pre-query trigger to determine which column is in error.
>4.Inspect the select statement to determine which column name is
>incorrect.
>5.Execute the form with Debug Mode activated.
>
>
>
>In article <fXYe5.109$fQ2.17175_at_wdc-read-01.qwest.net>,
> "Mike Dwyer" <dwyermj_at_co,larimer.co.us> wrote:
>> "kushan" <vikasmamta_at_my-deja.com> wrote in message
>> news:8l9vtj$kr1$1_at_nnrp1.deja.com...
>> > Help me, I have question
>> > What is the pupose of key-others trigger in forms?
>> >
>> Use this trigger to provide greater control over your form by
 restricting
>> what the users can do. The only line in the trigger is NULL; Then
 activate
>> only the keys you want active, for example Execute Query, with the
>> corresponding function in the key's trigger: Key-ExeQry is
 EXECUTE_QUERY;
>>
>> In a GUI environment, however, this technique is probably passe'.
>>
>> > for what system.message_level variable is used in forms?
>> > means its controls which kind of messages user written or system or
>> > both
>> >
>> This is the only system variable you can change; the others are read-
 only.
>> Oracle error messages have severity levels, and the lowest-severity
 messages
>> are only informational. To prevent unnecessary messages from being
 displayed
>> by a procedure, increase the message_level before executing the
 procedure.
>>
>> An example is FRM-40301...no records...retrieved resulting from an
>> Execute_Query. This may be a nuisance message in some situations, and
 it can
>> be supressed by setting message_level to 30 before the Execute_query
>> statement. (Be sure to set message_level back to its previous value
 after
>> the query.)
>>
>> > Sent via Deja.com http://www.deja.com/
>> > Before you buy.
>>
>>
Received on Mon Jul 24 2000 - 00:00:00 CEST