<div dir="ltr"><div><div>INSERT INTO table (clientId, field1, field2, field3)<br>SELECT 2, field1, field2, field3<br></div>FROM table<br></div>WHERE clientId = 1;<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Tue, Jul 29, 2014 at 8:05 AM, John C <span dir="ltr"><<a href="mailto:jc@sunshinesoftware.co.nz" target="_blank">jc@sunshinesoftware.co.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-NZ"><div><p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue">Hi all<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue">I have a table with a CLIENT index field. How can I copy (within the same table) the contents from one client to another client?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue">Table structure: Client_ID, Field1, Field2, Field3<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue">Before 1, 222, 333, 444<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue"> 1, 555, 666, 777<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue">After 1, 222, 333, 444<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue"> 1, 555, 666, 777<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue"> <b>2</b>, 222, 333, 444<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue"> <b>2</b>, 555, 666, 777<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:blue">Thanks a lot<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></span></p><span class="HOEnZb"><font color="#888888"><p class="MsoNormal">
<span style="font-family:"Arial","sans-serif";color:blue">John C<u></u><u></u></span></p></font></span></div></div><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" target="_blank">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></blockquote></div><br></div>