1) You can do that using SRW.FORMAT builtin available in REPORTS which
can dynamically set the color to Red based on value of some column
2) Try writing the following code in WHEN-NEW-FORM-INSTANCE
SET_FORM_PROPERTY(<your form name>,status,QUERY_STATUS)
Usually EXECUTE_QUERY built-in package is written in
WHEN-NEW-BLOCK-INSTANCE of the base table block . But this depends on
your application Forms automatically issues a EXECUTE_QUERY when you try
to query a base table block using F8 key.
3) PRE-FORM, WHEN-NEW-FORM-INSTANCE, PRE-BLOCK,
WHEN-NEW-BLOCK-INSTANCE, WHEN-NEW-RECORD-INSTANCE, PRE-TEXT-ITEM,
WHEN-NEW-ITEM-INSTANCE
But the sequence of firing depends whether you have triggers or not.
Hope this helps you.
>>> Nandeesha S <[Email Address Removed] 02/28/03 01:35AM >>>
Hi List/Nishant,
Pls help me on this .
1) say u have one report and the value is going negative (may be sum of
one
column or one field).I want to make the text of it in RED colour, how i
do
that ..??
2) In forms when the form gets opened, it should be in query mode ..
in
which trigger i will write exexute_query...??
3) what and all the triggers fire when the form gets opened and the
sequence..??
Thanx in Advance
Best Regards
Nandeesha S
DISCLAIMER: Information contained and transmitted by this E-MAIL is
proprietary to Mascot Systems Limited and is intended for use only by
the
individual or entity to which it is addressed, and may contain
information
that is privileged, confidential or exempt from disclosure under
applicable
law. If this is a forwarded message, the content of this E-MAIL may not
have
been sent with the authority of the Company. If you are not the
intended
recipient, an agent of the intended recipient or a person responsible
for
delivering the information to the named recipient, you are notified
that any
use, distribution, transmission, printing, copying or dissemination of
this
information in any way or in any manner is strictly prohibited. If you
have
received this communication in error, please delete this mail & notify
us
immediately at [Email Address Removed] Before opening attachments,
please scan for viruses.
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page