Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2008
    Posts
    4

    Unanswered: urgent trigger help

    When i enter a new product into the product table, i need to be able to insert a new row in the price table....can anyone help me with this?

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Not without ANY information on structure of the product table or the price table? The people of this forum are sharp, but we are not mind readers.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Oct 2008
    Posts
    4
    well i was just after a brief layout of a trigger for me to follow
    ie,

    create trigger <trigger name>
    insert....
    etc etc

  4. #4
    Join Date
    Oct 2008
    Posts
    4
    product table
    PRODID NUMBER (6),
    DESCRIP VARCHAR2(30),
    CONSTRAINT PRODUCT_PK PRIMARY KEY (PRODID)


    price table

    PRODID NUMBER (6),
    STDPRICE NUMBER (8,2) NOT NULL,
    MINPRICE NUMBER (8,2) NOT NULL,
    STARTDATE DATE,
    ENDDATE DATE,

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    So, after the row has been inserted into the PRODUCT table, what exactly would you want to insert into the PRICE table? PRODID should not be a problem, but how is anyone supposed to guess STDPRICE and MINPRICE values?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •