Hi all,
I have a sequence on a column which gets populated whenever a any user inserts a new record. Now we would like to restrict the sequence population only to certain users and allow superior users to insert their own values in the field via Form rather than the sequence. Is there any way...
When you boot he CD and get to the first installation screen, NOTE: Depending on your needs:
Type Linux nousb......then enter if no need for usb.
Type Linux noprobe......then enter if no need for RedHat to probe your hardware.
Type Linux nofirewire......then enter if no need for additional...
You can do pretty anything with any filesystem with Partition Commander. I use it all the time. In fact. I just used it to resized and changed NTFS to FAT32 yesterday. Go yo http://www.v-com.com/product/pc8_ind.html
You will see Partition Commander. Very good product. Good Luck!!!
Timi
Hi all,
I am trying to install Linux RedHat 9.0, but the installation freezes on me at "Loading ohci1394 driver"......and stays there for ever.
This installation was on my HP Pavillion laptop with Intel P4, WIN XP PRO. What suprises me most was that I installed the same software on...
I am trying to use SQL*Loader and getting the following error either with a shell script, or windows DOS. The TOAD was unable to finish the job either. I changed the SQL*Loader file, reinstalling the Oracle Database Utilities.....no fix. Is there any patch to fix this problem or if I can...
Thanks guys, I was able to come up with this program below and it worked perfectly.
DECLARE
CURSOR cur_wo
IS
SELECT a.workorder_no AS workorder_no, a.loccode
FROM z_activity a, z_invoice i
WHERE a.item_no = i.item_no;
wo_rec cur_wo%ROWTYPE;
BEGIN
OPEN cur_wo;
LOOP
FETCH cur_wo INTO wo_rec...
I have a need to populate a table with a large records and lot of colums. I have the following tables involved:
z_location, z_activity and z_invoice.
I added a new column (workorder_no)from z_invoice to z_location.....now having the following colums: Note: Workorder_no is an empty column...
How can I maximize windows in Oracle 9i Form. I tried using the WHEN-NEW-FORM-INSTANCE trigger Set_window_property(forms_mdi_window,window_state,maximize);, I got nothing, also tried to increase the window's width and height, no luck.
On-populate-details fires when Form Builder needs to fetch records into a block, while On-clear-details fires when Form Builder needs to clear those records
To answer the question the On-populate-details fires first, and On-clear-details fires afterwards.
...AND Cut_Date IS NOT NULL
AND Cust_Id IS NULL;
V_Start_Card := V_Start_Card + 1;
END LOOP;
IF NOT FORM_FAILURE THEN
/* Show Messages with Severity Level > 5 */
:SYSTEM.MESSAGE_LEVEL := '5';--trap error and suppress
--committing using DML...
Thanks lewisp and Dima, finally, I was able to achieve the objective. This will really help in the upcoming project since nobody including myself knows how to achieve this result. I was able to pull up more than three windows for the analysis. Appreciate it!!! :)
Thanks guys!!! So far so good, I got the List Item created. Dima was right about me not finding the WHEN-LIST-CHANGED trigger. I was actually trying to create the List Item Trigger on my existing item. By the way, I was able to create the List Item, the trigger, which compilled sucessfully...
When I research this issue further on Oracle website, I found out that WHEN-LIST-CHANGED Trigger is posible in Form/Block/Item levels, but the problem is when you try to create this trigger under an item, WHEN-LIST-CHANGED Trigger" was not listed. It was listed in both Form and Block...
The WHEN-LIST-CHANGED trigger does not exist at the Item level, only at the Form and Block level. That exacly is my problem. If I place this trigger either on the form or block level, how will this trigger call all the modules I wanted to listed in the combo list....just like LOV. Do I write...
Hey Lewisp,
Can you expanciate on putting the OPEN_FORM into any non-validation style triggers. I will not mind the steps. I do not have any idea of this step. I already created Form Level Trigger for my "WHEN-LIST-CHANGED Trigger". Inside the PL/SQL Editor were...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.