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

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

I am trying to have input for criteria for my where statement in sql. I am using a .bat file to prompt for a password (WORKS GREAT), then run the sql script (.ctl) that exports data. I need it to allow the user to enter a vendor name. My only guess is an Accept, but I have never used it...

Yup, it worked. Thanks alot!!

I tried it several different ways, but could not get it to work. Perhaps the following result will help. Note: I have also disabled all related triggers, still not working. I HOPE SOMEONE CAN HELP? I am trying to update QUOTATIONLINE2.ITEMNUM TABLE QUOTATIONLINE2 RFQNUM RFQLINENUM...

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