Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sschandhok

    Solution for Error message in SQL Server 7 Enterprise Manager

    Using the Enterprise Manager. First click on the Table on the tree and creating a table. Open the relationship and trying to add the table in the relationship ,it gives an error message CoIntialize has not been Called. How to correct this error and why is the error occuring.
  2. sschandhok

    trigger question

    create trigger <trigger-Name> before delete on <any table namae other than the employee> for each row begin check_delete(:old.emp_no,:old.emp_sysdate); end; You should make emp_no as a primary key and then do the following: Create a temp table so that you have two field(the parameters which...
  3. sschandhok

    Oracle

    drop trigger t; create trigger t before insert on temp1 for each row declare name varchar2(20); begin select empname into name from temp where emp_id=:new.emp_id; if (lower( name))='man' then raise_application_error(20,'sdfdfds'); end if; end;
  4. sschandhok

    Oracle

    HI ALL! I have a problem in creating a trigger. I have got two tables as follows: create table temp ( EMP_ID number(5) Primary Key, ENAME varchar2(10) ); create table temp2 ( EMP_ID number(5) references temp(EMP_ID), salary number(5) ); I am suppose to create a trigger which will not allow...

Part and Inventory Search

Back
Top