OraFAQ Forum: Forms » Help Help Help Help Plzzzz?

Home » Developer & Programmer » Forms » Help Help Help Help Plzzzz?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help Help Help Help Plzzzz? [message #246420]

Wed, 20 June 2007 17:19

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

Report message to a moderator

Re: Help Help Help Help Plzzzz? [message #247202 is a reply to message #246420]

Mon, 25 June 2007 01:03

djmartin
Messages: 10181
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.

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 01:44:58 CST 2024