sql strange, VSTUDIO and V4MD 4.3

[Ivan Smahin]

Hello Christian,

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;


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com