<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>+1 to this :)</p>
<p>On 06/03/2017 11:02, David O'Brien wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">Run a separate SQL query?<br /> <br /> -----Original Message-----<br /> From: <a href="mailto:delphi-bounces@listserver.123.net.nz">delphi-bounces@listserver.123.net.nz</a> [mailto:<a href="mailto:delphi-bounces@listserver.123.net.nz">delphi-bounces@listserver.123.net.nz</a>] On Behalf Of Marshland Engineering<br /> Sent: Monday, 6 March 2017 10:47 am<br /> To: <a href="mailto:delphi@listserver.123.net.nz">delphi@listserver.123.net.nz</a><br /> Subject: [DUG] A better way of checking if duplicate exists<br /> <br /> 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. <br /> <br /> If I use a locate, I end up on the matching record and not on my current one. <br /> <br /> 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.<br /> <br /> Any suggestions ?<br /> <br /> Thanks Wallace<br /> <br /> _______________________________________________<br /> NZ Borland Developers Group - Delphi mailing list<br /> Post: <a href="mailto:delphi@listserver.123.net.nz">delphi@listserver.123.net.nz</a><br /> Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><br /> Unsubscribe: send an email to <a href="mailto:delphi-request@listserver.123.net.nz">delphi-request@listserver.123.net.nz</a> with Subject: unsubscribe<br /> <br /> _______________________________________________<br /> NZ Borland Developers Group - Delphi mailing list<br /> Post: <a href="mailto:delphi@listserver.123.net.nz">delphi@listserver.123.net.nz</a><br /> Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><br /> Unsubscribe: send an email to <a href="mailto:delphi-request@listserver.123.net.nz">delphi-request@listserver.123.net.nz</a> with Subject: unsubscribe</div>
</blockquote>
<p><br /></p>
</body></html>