This discussion is archived
2 Replies Latest reply: Dec 8, 2012 1:31 AM by Sachinmrt RSS

suggest the best method to find the duplicate values entry in the form

628509 Newbie
Currently Being Moderated
Hi,

Can u plz suggest a best logic for duplicate checking in forms while entering the data.
for e.g when we enter empno,empname,sal etc.. details in a base table block,
empname should not be duplicate. For this purpose for each entry of empname, I am using the logic in such a way that
it will check from first record to last record in the loop. If entered empname already exists in the block it shows the error message.
for this purpose I use the system variable system.cursor_record, Name_in function etc..
But in the case of thousands or lacks of record in the form, Is this logic useful?? Plz suggest a best logic if you have?

with thanks

gms

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points