2 Replies Latest reply: Dec 8, 2012 3:31 AM by Sachinmrt RSS

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

    628509
      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