What is the best way to handle duplication check?
Date: Sat, 22 Oct 1994 10:00:26 GMT
Message-ID: <kenho.101.2EA8E2B9_at_hk.super.net>
Hi, Oracle gurus
I am using Forms 4.0.12 under MS Windows.
I am now reviewing the Chart of account setup Form. The main problem I found so far is that when I need to check the duplication.
My problem is:
When a user attempt to create a new account, she need to type in a account no.
My job is to make sure that she does not typing duplicate account no. But if
the user is typing the new no and not yet commit. The record is not found
on the table yet, so the select statement will not find it and the
program will assume the account no is not a duplicate.
Currently I am using a timer to scan through the whole block, but I found that this approach is very slow....
Can anyone suggest a better method? Any suggestion are strongly appreciated.
Ken Received on Sat Oct 22 1994 - 11:00:26 CET