sql strange, VSTUDIO and V4MD 4.3

[Ruslan Zasukhin]

On 6/14/10 9:50 AM, "Ivan Smahin" <ivan_smahin at paradigmasoft.com> wrote:

>> but I have other problem :
> 
>> I have, for example,
> 
>> "select recID, scrap from tableScrap where recID IN (7, 23, 1)"
> 
>> but I want records IN ORDER of "IN" : 7, 23, 1 and not 1, 7, 23
> 
>> do you have a solution ?

I wonder guys.

"select recID, scrap from tableScrap where recID IN (7, 23, 1)"

Don't return records in that order 7 23 1    ???

Ivan?

Well, may be bitsets are used ...


> select recID, scrap from tableScrap where recID = 7
> UNION
> select recID, scrap from tableScrap where recID = 23
> UNION
> select recID, scrap from tableScrap where recID = 1;

-- 
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]