Recent content by kilabru

I am using a trigger that takes input from a user via a valuelist. The valuelist is a locations list. The trigger looks at the selected location and then looks at a status in a corresponding table to determine if it is disabled. If it is disabled it returns an application error. I would...

I figured it out shortly after my post. It has been tested and works great. Please refer to code if you desire. Thanks for eveyone's input. create or replace trigger john_labor before insert or update of laborcode on labor for each row declare v_ss2 labor.rowstamp%type; v_ss...

This is my code and error 1 create or replace trigger john_labor 2 after insert or update of laborcode on labor 3 for each row 4 begin 5 IF :new.LA21 is null THEN 6 :new.LA21 := :new.laborcode; 7 END IF; 8* End; SQL> / create or replace trigger john_labor...

I have a table called LABOR. In this table I have columns named: LABORCODE, LA21, NAME, ROWSTAMP I am wanting to create a trigger that will insert into LABORCODE after an insert into LABOR. My example is that I insert a new record so I want LABORCODE to equal 'JOHN'. My real desire is to have...

I have two fields A & B. A B 1234567 Holly, Robert I want to pull the first three numbers from A and the first three letters from B and conectate them in another field. Can anyone tell me how to do this? Thanks

what does autokey.seed do? i have a script that inserts a seed, but I have no idea what it is

Can you export a report as a PDF file? If so, how? Thanks, John

I have 4 tables of data. 3 tables link to the main table ITEM via itemnum As the following depicts, I am wanting to take the three individual select statements and run them as a sum with the particular itemnum. In other words, I want it to look similar to the desired output: ITEMNUM...

Is there a way to display a message that would say, "DEMOLISHED LOCATION" along with the return of a null in the following code? In other words, I want a message or dialog box to pop up that says it is DEMOLISHED. Here is the code. Create or Replace Trigger trigg_loc_stat AFTER...

I have two tables, A & B. In table A & B there is a column called location. In column B, there is also a column called status. In the application, I am entering a location from Table A. When I do this, I want to lookup the corresponding location in table B and return a null value if the...

I am using a .bat file to be used for security with my application. In doing so, my testing was completed in the Windows 2000 environment. Everything worked great. Now I am trying it in NT, will not prompt for input. Can anyone help me? This is my last process step. Here is my 2000...

Well, I still want it to ask the user for criteria. I just don't want the "ENTER VALUE" part to be in my output file...in this case a .txt file. Is that even possible?

I set verify off and this my result now: Enter value for 2: 'IR' 1000*200*IR******************* Is there a way to get rid of the Enter value part??

Got it

I am exporting test with criteria. How do I prevent the user input from showing up on the output file? The argument is in the where clause. I am using a .bat file to run the script, don't know if that helps. I have provided results and script. Results: Enter value for 2: 'IR' old 8...