OraFAQ Forum: Forms » Help In Execution Query

Home » Developer & Programmer » Forms » Help In Execution Query

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

Help In Execution Query [message #251799]

Mon, 16 July 2007 12:40

hussienburhan
Messages: 28
Registered: July 2007

Junior Member

HI
I CREATE DATABASE AND I DEFINE ONE COLUMN CALLED REC_STAT THIS RECORD FOR HIDING DATA ITS FROM TYPE VARCHAR2(1), THEN I MADE FORM I WANT TO CALL ONLY RECORDS THAT REC_STAT='A' WHEN EVER I PRESS EXCEUTE QUERY BUTTON IN THE MENUE SO THERE MUST BE CONDITION THAT THE RECORD MUST BE REC_STAT='A'

HOW CAN I MAKE THIS WHAT IS THE TRRIGER PLZ HELP ME . :blush:

Report message to a moderator

Re: Help In Execution Query [message #251800 is a reply to message #251799]

Mon, 16 July 2007 12:43

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

http://infolab.stanford.edu/~ullman/fcdb/oracle/or-triggers.html

Report message to a moderator

Re: Help In Execution Query [message #252128 is a reply to message #251800]

Tue, 17 July 2007 22:35

bahubcd
Messages: 40
Registered: July 2007
Location: Bangalore

Member

Go to the property pallete of the data block of the table.
Set the where clause to the condition
rec_st = 'A'

Then it will work as per your need.. I dont think you need a trigger for this.

Please revert back in case i have not answered your question properly..

Report message to a moderator

Re: Help In Execution Query [message #252212 is a reply to message #251799]

Wed, 18 July 2007 02:50

hussienburhan
Messages: 28
Registered: July 2007

Junior Member

Thank You Very Much Mr bahubcd Yes That was the solution

Report message to a moderator

Previous Topic:	Can we develop a messenger application using 6i or 9i
Next Topic:	How To Call Form Through Another Fome(Help)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 00:19:18 CDT 2024