<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I complete : I use V4RB 4.9.1 with RB 2011 4.2 enterprise, mac os x 10.6.8, macPro 2.1<div>I use VS 4.9 for Mac<br><div><br><div><div>Le 25 févr. 2012 à 15:32, Christian - <a href="http://ChrisKatDev.com">ChrisKatDev.com</a> a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="background-color: transparent;">Hi Ruslan,</span><div><span class="Apple-style-span" style="background-color: transparent;"><br></span></div><div><span class="Apple-style-span" style="background-color: transparent;">I have 500,0000 record in database.</span></div><div><span class="Apple-style-span" style="background-color: transparent;">Where I want delete without limit, I have a crash (database diagnose : ok)</span></div><div><span class="Apple-style-span" style="background-color: transparent;"><br></span></div><div><span class="Apple-style-span" style="background-color: transparent;">I have tried :</span></div><blockquote type="cite"><div><blockquote type="cite"></blockquote></div></blockquote><div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="background-color: transparent;">delete from dicowords where recid in (select recid from dicowords where reciddictionary = 4 ORDER BY recid limit 1000)</span></font></div></div></div><div><span class="Apple-style-span" style="background-color: transparent;"><br></span></div><div><span class="Apple-style-span" style="background-color: transparent;"> but I have this error...</span></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="background-color: transparent;">15:28:50 Kernel error: 0x71000. line 1:93: expecting ')', found 'ORDER'</span></font></div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="background-color: transparent;"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="background-color: transparent;">??</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="background-color: transparent;"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="background-color: transparent;">Christian</span></font></div><div><br><div><div>Le 25 févr. 2012 à 15:03, Ruslan Zasukhin a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>On 2/25/12 3:13 PM, "Christian - <a href="http://ChrisKatDev.com/">ChrisKatDev.com</a>"<br><<a href="mailto:christian@chriskatdev.com">christian@chriskatdev.com</a>> wrote:<br><br><blockquote type="cite">hello,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">why this request don't work :<br></blockquote><blockquote type="cite">delete from dicowords where recid in (select recid from dicowords where<br></blockquote><blockquote type="cite">reciddictionary = 4 limit 1000)<br></blockquote><br>You want delete ANY first 1000 records?<br><br>ANY because you not specify ORDER BY ... So you can get random records in<br>this set ...<br><br>Well, I'd say - first 1000 records in their physical order in table ...<br><br><br>-- <br>Best regards,<br><br>Ruslan Zasukhin<br>VP Engineering and New Technology<br>Paradigma Software, Inc<br><br>Valentina - Joining Worlds of Information<br><a href="http://www.paradigmasoft.com/">http://www.paradigmasoft.com</a><br><br>[I feel the need: the need for speed]<br><br><br>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></div></blockquote></div><br></div></div>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></blockquote></div><br></div></div></body></html>