[DUG] A better way of checking if duplicate exists

[Pieter De Wit]

+1 to this :) 

On 06/03/2017 11:02, David O'Brien wrote:

> 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
> 
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20170306/13003ae5/attachment.html