OraFAQ Forum: Forms » duplicate records

Home » Developer & Programmer » Forms » duplicate records (r12,10g)

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

duplicate records [message #516487]

Mon, 18 July 2011 11:05

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

hi

there is non database data block of table type.

now i want restrict user that he will not enter same number again.

can anyone suggest way..?

Report message to a moderator

Re: duplicate records [message #516488 is a reply to message #516487]

Mon, 18 July 2011 11:14

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As the block is a control block, you can't POST anything and then SELECT from the table because - there's no table.

Therefore, you'll have to scroll through the whole block and compare the latest value with previously entered ones. This is done in a loop.

Report message to a moderator

Re: duplicate records [message #516490 is a reply to message #516488]

Mon, 18 July 2011 11:19

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

how can i scroll through whole block as it is non database...?

Report message to a moderator

Re: duplicate records [message #516491 is a reply to message #516490]

Mon, 18 July 2011 11:31

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

In a loop (there's no difference whether it is a database or a control block; why do you think that there is - regarding scrolling up and down?).

l_current_number := :block.numeric_item
first_record
loop through all records
  if l_current_item = :block.numeric_item 
     message (error - same numbers)
  end if
  next_record
end loop

Report message to a moderator

Previous Topic:	Upload file field
Next Topic:	CLIENT_HOST is not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 03 16:12:57 CDT 2026