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
Messages: 38
Registered: April 2007


* 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

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.

Re: Help Help Help Help Plzzzz? [message #247202 is a reply to message #246420] Mon, 25 June 2007 01:03 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS 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.

Previous Topic: excel downloading
Next Topic: PDE-PLI018 Error
Goto Forum:

Current Time: Wed Aug 23 18:27:29 CDT 2017

Total time taken to generate the page: 0.16929 seconds