[DUG] A better way of checking if duplicate exists

[David O'Brien]

Run a separate SQL query?

-----Original Message-----
From: delphi-bounces at listserver.123.net.nz [mailto:delphi-bounces at listserver.123.net.nz] On Behalf Of Marshland Engineering
Sent: Monday, 6 March 2017 10:47 am
To: delphi at listserver.123.net.nz
Subject: [DUG] A better way of checking if duplicate exists

I have a form linked to a tbl. When I enter data into the form, there is one field that needs to be checked for duplicates. 

If I use a locate, I end up on the matching record and not on my current one. 

Basically I want to disable all tables and screen updates, do a search and if found, set a flag and in either case the return the to the original workspace.

Any suggestions ?

Thanks Wallace

_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at listserver.123.net.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe