sql strange, VSTUDIO and V4MD 4.3

Mon Jun 14 06:02:17 CDT 2010

Le 14 juin 2010 à 08:50, Ivan Smahin a écrit :

> Hello Christian,
Hi Yvan,
> 
> Sunday, June 13, 2010, 5:28:18 PM, you wrote:
> 
>> ok only in Director...
> 
> BTW, this issues is fixed already
> http://www.valentina-db.com/bt/view.php?id=4930
> 
> 
>> 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 ?
> 
> 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;

in this example, I have only 3 records, but, in practice, I can have 10000 records !!
I only want save my order...

br
Christian

> 
> 
> -- 
> Best regards,
> Ivan Smahin 
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina