Search results for query: *

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...

...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 * ERROR at line 1: ORA-04084: cannot change NEW values for this...

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

...if that helps. I have provided results and script. Results: Enter value for 2: 'IR' old 8: where vendor = &2 new 8: where vendor = 'IR' 1000*200*IR*******************...

...echo off set termout off set pagesize 0 set heading off set feedback off set serveroutout off set linesize 1000 spool graybar_out.txt ACCEPT john select rfqnum||'*'||rfqlinenum||'*'||vendor||'*' from quotationline where vendor = john; quit --------------------------------- Thanks, John

Yup, it worked. Thanks alot!!

...where rfqnum=quotationline.rfqnum; end loop; end; SQL> / set itemnum = quotationline.itemnum where ....... * ERROR at line 7: ORA-06550: line 7, column 16: PLS-00327: "QUOTATIONLINE" is not in SQL scope here ORA-06550: line 6, column 2: PL/SQL: SQL Statement...

THE FOLLOWING IS THE BODY IF A TRIGGER THAT I AM USING IT WORKS GREAT, BUT I HAVE PROBLEM. I NEED TO PULL A COLUMN FROM ANOTHER TABLE THAT IS LINKED TO THIS TABLE VIA RFQNUM. THE OTHER COLUMN IS CALLED "VENDOR" LOCATED IN RFQVENDOR TABLE. IS THIS POSSIBLE? THIS TRIGGER IS WITHIN A...

I GOT IT!! @ECHO OFF SET MyInput= IF '%1'=='A' GOTO Ready SET /P MyInput=Enter filename: %0 %MyInput% :Ready