Home » Developer & Programmer » Forms » Help In Execution Query
Help In Execution Query [message #251799] Mon, 16 July 2007 12:40 Go to next message
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:
Re: Help In Execution Query [message #251800 is a reply to message #251799] Mon, 16 July 2007 12:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://infolab.stanford.edu/~ullman/fcdb/oracle/or-triggers.html
Re: Help In Execution Query [message #252128 is a reply to message #251800] Tue, 17 July 2007 22:35 Go to previous messageGo to next message
bahubcd
Messages: 36
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..
Re: Help In Execution Query [message #252212 is a reply to message #251799] Wed, 18 July 2007 02:50 Go to previous message
hussienburhan
Messages: 28
Registered: July 2007
Junior Member
Thank You Very Much Mr bahubcd Yes That was the solution
Previous Topic: Can we develop a messenger application using 6i or 9i
Next Topic: How To Call Form Through Another Fome(Help)
Goto Forum:
  


Current Time: Sat Dec 03 20:11:01 CST 2016

Total time taken to generate the page: 0.27967 seconds