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

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

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

ORCALE 8i / SQLPLUS I have two tables, One and Two Table One: Main table that consists of three columns A, B, C, & D. Columns A & B will always have data while C & D do not. After insert to One, a trigger executes and sends a copy of the row to another table called Two. Table Two will then...

I am using a buttom in a program that I want to ask for a password through a .bat file. This is the only way I am able to add security to the button. What it does? It is a link that opens and runs several scripts(SQL)that I only want a few people to have this ability. Is this possible? Can...

Exporting: USING: .bat & .ctl to .txt Exporting is all good and grand. However, my data keeps wrapping in the .txt file. End result, my data will not load into tables due to the wrap. All my data needs to stay on one line record. I have turned wrapping off, but it always wrap. One...