• Table Level Triggers – Triggers on Two Fields Within the Same Table

    Hi, I was wondering if some can have a look at the following triggers on a single table but on two different Fields that are referenced in both triggers: CREATE OR REPLACE TRIGGER AAL015_HWT_TRG BEFORE INSERT OR UPDATE ON AAL015 REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW BEGIN IF INSERTING OR...

    SamAvella30 pointsBadges:
  • Store Procedures, SQL statements

    I am a newby to SQL and I am currently creating a store procedures for Crystal Reports. I have ran into a Problem. Here is some of my coding: SELECT @Address = ISNULL(Address,'') from tblAddresses WHERE (ClientNumber = @ClientNumber) AND (AddressType = 'Current') IF LTRim(RTrim(@Address)) <>...

    Jewels010 pointsBadges:
  • Problems sending specific attachments

    I am the exchange administrator for my organization. We have 3 exchange clusters (exchange 2000 SP4), a front end server, and use an SMTP connector to send outbound mail. We use a third-party vendor as a smart host for all our outbound email. My problem is this: I am getting complaints that...

    Technochic57,010 pointsBadges:
  • terminal server and gpo

    i have a server 2003 that configure as a terminal server, and i want implement a strict acess to this server from client (xp pro) to that server, i create ou that called "for terminal users" and create for that ou a gpo, now,, i want to know how should i change the gpo to achive the next goals: 1....

    Drorbeny0 pointsBadges:
  • Running a script at specified runtime

    I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

    Columbus0 pointsBadges:
  • Can’t login as Administrator

    Hello Everybody, I can't login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it...

    BinooDas123410 pointsBadges:
  • Using Secure Shell (ssh)

    I have to submit a remote command from the AS/400 to run on a UNIX system. I am told by security admin. that I can only use Secure Shell(ssh). Both the AS/400 and the UNIX server are within the firewall. I do not know where to start. Does OS/400 V5R3 have this capability? Do I need additional...

    Ashnirody100 pointsBadges:
  • Network Resource Allocation cum Planning cum Technical Problem

    This is the real commercial problem face by my company. Well, the reason I ask this problem is I salute and respect all of you as I believe all of you are as good as network solution company out there, or even better!! Lets me rephrase the entire problem again. Company expand so fast that the IT...

    Hunkgym5 pointsBadges:
  • End Program – explorer.exe-2

    From last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes one after another. The...

    BinooDas123410 pointsBadges:
  • static ip is in the spam list

    HELLO ALL, My static ip is in the spam list. What should I do? Thanks a lot

    UNIVERCITY0 pointsBadges:
  • Start-up Needed for DB design for workflow for BPO company

    Can any one give some usefull and urgent tips about database design example where i get for designing BPO company work flow parts...

    Malaikanirr0 pointsBadges:
  • Capture screen w/scrolling marquee

    My company uses a 3rd party software. There's one screen that has a few graphs and a few lines that scroll across the screen. Similiar to a Screen Saver's Scrolling Marquee. They redesigned the software and this screen will no longer exist. I would like to capture this screen w/scrolling marquee....

    Drew65220 pointsBadges:
  • Reddot CMS

    I'm looking for others that have had exposure to Reddot CMS. What are you thoughts on this application?

    MadMaxB0 pointsBadges:
  • XLS integration to Iseries

    I am looking for information on getting XLS data to the Iseries. Specifically would like to get XLS into XML format so an EDI/XML translator can pick it up and send through our existing EDI processes. The XLS will come from e-mail clients.

    Roses060 pointsBadges:
  • Zebra printer will not print CORRECTLY through Oracle application(s)

    Glad to see that some of you all have experience with Zebra printers!!! My problem is that I cannot get my custom Oracle application to print correctly to a Zebra TLP 2742 printer. The problem started when an (older) hand held "pistol" scanner failed. Connected to a laboratory balance via Omnilink...

    Poppaman20 pointsBadges:
  • M$ Small Business Accounting Outlook toolbar missing

    M$ SBA SP2 had a toolbar in the Outlook calendar that allowed converting of calendar appointments to time entries in SBA. It's gone now and I don't know how to get it back. I've uninstalled and reinstalled SBA and SBA SP2 with no luck. Any ideas? Thanks, Joel

    Joelsplace0 pointsBadges:
  • File Transfer

    How do I transfer a Excel Spreadsheet to the AS400? Thank you Marymartha

    Mbaccarny0 pointsBadges:
  • List of Values in a SP Parameter

    I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin Declare C1 Cursor with Return For Select * From Table1 WHERE Field1 in('Value1', 'Value2','Value3',...

    Saratusthra0 pointsBadges:
  • Passing parameters from .ASP (VBSript) to Activex object in date format

    I have inherited the following: <%@ LANGUAGE="VBSCRIPT" %> <% dim adoconn set adoconn = server.createobject("adodb.connection") adoconn.open Application("DSN"),Application("UID"),Application("PWD") reportname = "traininghrsbyemployee.rpt" If Not IsObject (session("oApp")) Then Set...

    Avdberg0 pointsBadges:
  • Question about a frequently changing column as primary key

    Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance...

    Paulachen0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following