Home » Developer & Programmer » Forms » Unique record in block on form at runtime (11i)
Unique record in block on form at runtime [message #663691] Wed, 14 June 2017 09:19 Go to next message
rahuld
Messages: 6
Registered: November 2016
Junior Member
Hi All,

I have one data base block. block having three columns FNF1,FNF2,FNF3 and ten rows.

My requirement is on form level at runtime if I enter data in any column, this date should not be same anywhere in the block at form level and it should give the message as "Data is duplicated".


Please help,

Thanks,
Rahul




Re: Unique record in block on form at runtime [message #663697 is a reply to message #663691] Wed, 14 June 2017 12:40 Go to previous messageGo to next message
joy_division
Messages: 4961
Registered: February 2005
Location: East Coast USA
Senior Member
Just create a unique index and let the database handle it for you.
Re: Unique record in block on form at runtime [message #663705 is a reply to message #663697] Thu, 15 June 2017 00:45 Go to previous messageGo to next message
rahuld
Messages: 6
Registered: November 2016
Junior Member
Hi Joy,

Thanks for your reply.

If I use unique index then I can insert column FNF1 value in FNF2.

But my requirement is column FNF1 value can not be enter in column FNF2 and FNF3 in any row. same as FNF2 value can not be enter in column FNF1 and column FNF3. And FNF3 value
can not be enter in column FNF1 and FNF2.

Means all the data should be unique. It will not present any column any rows.. it is always unique.

Thanks,
Rahul




Re: Unique record in block on form at runtime [message #663719 is a reply to message #663705] Thu, 15 June 2017 03:31 Go to previous messageGo to next message
Littlefoot
Messages: 21690
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That sounds like Sudoku.

Well, you could create a global temporary table and store each and every form item value into it, checking whether it already exists (and raise a warning) or not (and store it).
Re: Unique record in block on form at runtime [message #663721 is a reply to message #663719] Thu, 15 June 2017 03:44 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
And this begs the obvious question - does the restriction just apply to data currently in the form, or all data in the table as well?
Re: Unique record in block on form at runtime [message #663893 is a reply to message #663721] Fri, 23 June 2017 05:13 Go to previous messageGo to next message
rahuld
Messages: 6
Registered: November 2016
Junior Member
Hi,

I already used GTT table.. In that table I insert data using POST-TEXT-ITEM and it is work properly when I used TAB key...
But If use mouse for next field and I used same code on WHEN-MOUSE-CLICK trigger that time code is not working.

If I click on 1st line and enter data and go to next line and without enter data in 2nd line if i will try to go 1st line through mouse I am unable to go any line.
My cursor always come to 2nd line.

So Is it possible on WHEN-MOUSE-CLICK trigger too?

Thanks,
Rahul D
Re: Unique record in block on form at runtime [message #663897 is a reply to message #663893] Fri, 23 June 2017 06:10 Go to previous message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
post-text-item fires when you leave an item regardless of the method of navigation used. So why would you need when-mouse-click?
Previous Topic: Forms Cluster
Next Topic: Unable to start the 12c nodemanager , OHS1 and WLS_FORMS
Goto Forum:
  


Current Time: Tue Nov 30 16:24:08 CST 2021