Home » Developer & Programmer » Forms » Help Help Help Help Plzzzz?
icon8.gif  Help Help Help Help Plzzzz? [message #246420] Wed, 20 June 2007 17:19 Go to next message
Basit
Messages: 38
Registered: April 2007
Member

hello,

* SALES_REP_NAME and SALES_REP_ID item whenever validation
occurs on CUSTOMER_ID. Fail the trigger if the customer
is not found.

SALES_REP_NAME is a display item(NON DATABASE ITEM) and
SALES_REP_ID is DATABASE ITEM.

and the second one is this,


* Create another validation trigger on S_ITEM.PRODUCT_ID to derive
the name of the product and the suggested wholesale price
(is a database item) and wirte them to DESCRIPTION ITEM
(is a display item and non database item) and the PRICE ITEM
(Database item). Fail the trigger and display the message if the
product is not found.

Plz tell me the trigger which one to use? one which level? and what can be the code? need code too.i m not good in PL-SQL and kindly clerify for me what this means. i m student and this is a practice project for me.


thnx
Re: Help Help Help Help Plzzzz? [message #247202 is a reply to message #246420] Mon, 25 June 2007 01:03 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is there anyone else doing the course? Pretend to be their friend and buy them a local beverage and small plate of food while they explain how to write PL/SQL.

You use When-Validate-Item to validate an item and post-query to get information from other tables during a query.

Alternatively, read the manual, search this forum, or google it.

David
Previous Topic: how use loop in from for two block
Next Topic: multiple row relationship
Goto Forum:
  


Current Time: Sun Dec 04 00:36:09 CST 2016

Total time taken to generate the page: 0.07101 seconds