SQL RB AND VS (spec)

[Christian - ChrisKatDev.com]

I complete : I use V4RB 4.9.1 with RB 2011 4.2 enterprise, mac os x 10.6.8, macPro 2.1
I use VS 4.9 for Mac

Le 25 févr. 2012 à 15:32, Christian - ChrisKatDev.com a écrit :

> Hi Ruslan,
> 
> I have 500,0000 record in database.
> Where I want delete without limit, I have a crash (database diagnose : ok)
> 
> I have tried :
> delete from dicowords where recid in (select recid from dicowords where reciddictionary = 4 ORDER BY recid limit 1000)
> 
>  but I have this error...
> 15:28:50 Kernel error: 0x71000. line 1:93: expecting ')', found 'ORDER'
> 
> ??
> 
> Christian
> 
> Le 25 févr. 2012 à 15:03, Ruslan Zasukhin a écrit :
> 
>> On 2/25/12 3:13 PM, "Christian - ChrisKatDev.com"
>> <christian at chriskatdev.com> wrote:
>> 
>>> hello,
>>> 
>>> why this request don't work :
>>> delete from dicowords where recid in (select recid from dicowords where
>>> reciddictionary = 4 limit 1000)
>> 
>> You want delete ANY  first 1000 records?
>> 
>> ANY because you not specify ORDER BY ... So you can get random records in
>> this set ...
>> 
>> Well, I'd say - first 1000 records in their physical order in table ...
>> 
>> 
>> -- 
>> Best regards,
>> 
>> Ruslan Zasukhin
>> VP Engineering and New Technology
>> Paradigma Software, Inc
>> 
>> Valentina - Joining Worlds of Information
>> http://www.paradigmasoft.com
>> 
>> [I feel the need: the need for speed]
>> 
>> 
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120225/6e51787b/attachment-0001.html>