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?