OraFAQ Forum: Forms » Unique record in block on form at runtime

Home » Developer & Programmer » Forms » Unique record in block on form at runtime (11i)

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

Unique record in block on form at runtime [message #663691]

Wed, 14 June 2017 09:19

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

Report message to a moderator

Re: Unique record in block on form at runtime [message #663697 is a reply to message #663691]

Wed, 14 June 2017 12:40

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Just create a unique index and let the database handle it for you.

Report message to a moderator

Re: Unique record in block on form at runtime [message #663705 is a reply to message #663697]

Thu, 15 June 2017 00:45

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

Report message to a moderator

Re: Unique record in block on form at runtime [message #663719 is a reply to message #663705]

Thu, 15 June 2017 03:31

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: Unique record in block on form at runtime [message #663721 is a reply to message #663719]

Thu, 15 June 2017 03:44

cookiemonster
Messages: 13965
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?

Report message to a moderator

Re: Unique record in block on form at runtime [message #663893 is a reply to message #663721]

Fri, 23 June 2017 05:13

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

Report message to a moderator

Re: Unique record in block on form at runtime [message #663897 is a reply to message #663893]

Fri, 23 June 2017 06:10

cookiemonster
Messages: 13965
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?

Report message to a moderator

Previous Topic:	Forms Cluster
Next Topic:	Unable to start the 12c nodemanager , OHS1 and WLS_FORMS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 10:00:55 CST 2025