Hi Sameer, I think you should activate KEY-COMMIT trigger on form level, as far as I know you can't make duplicate record as long as you have constraint in your table. Using WHEN-VALIDATE-RECORD is fine, you just make a short query to check in your table whether your input is not already exist in table.
Rgrds, Sony > -----Original Message----- > From: Sameer Ghadge [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, January 30, 2003 12:09 PM > To: Multiple recipients of list ORACLE-L > Subject: forms6i question > > Hi All , > Can anyone tell me if there is any handle or cursor to a block record > buffer > ,which I can access in forms6i. > my requirement is to restrict user from entering duplicate records in the > block while inserting'em (but before saving them). > As soon as user enters the row TAB's out I want to check it with values > in > the other row in WHEN-VALIDATE-RECORD trigger > (Note that rows are not yet stored in the database) > > I have implemented this using PL-SQL table/Record Group by replicating > data > in the block with PL/SQL table, > (but it requires coding in many triggers) > I was wondering if there is more simple and efficient solution to this. > > Thanks > Sam > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sameer Ghadge > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
