I am having WHEN-NEW-ITEM-INSTANCE trigger at Form, Block, Item level what is the sequence of execution? And if I want to change there sequence how I have to change?
Hi, suppose i have 2 managers M1 & M2. S1 & S2 are Sales reps under M1. S3 & S4 are Sales reps under M2. Suppose S1 (whose manager is M1) creates 2 records. S2 will be able to see them ?.Now, if i change the parent position of S1 (i.e., if now, S1 is placed under M2 instead of M1), and responsibility remaining the same as earlier (Sales rep resp), will the Manager M1 be still able to see the records created by S1 ? Please clarify this. Thanks
Hai i have installed oracle 10g on my system.and it shows that Pro C has also been installed but i am not getting any access to PRO C i.e i am not getting PRO *C UI(user interface) .how to access or start PRO C UI. please help me out.also i installed Oracle HTTP server and oracle companion products on my system but but i am unable access HTML DB. on what port numnber it will be accessible .also need help how to access text file in oracle,pl/sqlplease helpits urgent.prabhash
Latest Answer : Hi,If a Form Item's property needs to be changed, then it should be done from a form trigger and not a database trigger. You can use Visual Attributes or Property Classes to achieve this or a form trigger. Depending on your criteria, you can use form ...
I want to tune the sql query written on two field change peoplecode please help me to tune the query as it is very urgent i am pasting the query isAMT1 = 0;AMT2 = 0;AMT3 = 0;AMT4 = 0;If All(DATE_FROM) Then &FROM = " and asof_dt >= %DateIn(:ml_gul_40a_wrk.date_from)";End-If;If All(DATE_TO) Then &TO = " and asof_dt
Latest Answer : alter session set nls_date_format ='new_date_ format';or use to_date functions ...
Can SYSTEM.CURRENT_BLOCK value be changed. If yes how? If no Why? Give with example
How do you send the output of your SQL* Plus session to a text operating system file
Latest Answer : well you want to see the output ina text file............this can be done by spooling the data;for example..you want to see the output of the details of all employees:do the following steps:spool c:satya.txt/select * from emp/spool off;now you can ...
In D2K How to change the label text of a boilerplate object dynamically, using conditional triggers?
