[V4MD] SELECT weirdness

[Ruslan Zasukhin]

on 9/28/03 4:46 PM, Martin Kloss at martin.kloss at gmx.de wrote:

Hi Martin,

> I get 0 records with the following SELECT statement,
> which seems perfectly alright to me:
> 
> SELECT RecID,* FROM data WHERE RecID = 2 ORDER BY RecID
> 
> The table has two records with RecID 1 and 2
> 
> BUT the query works when I drop the "ORDER BY" clause:
> 
> SELECT RecID,* FROM data WHERE RecID = 2

Yes.

1) what sense to order on RecID ?

2) and Valentina always return you records ordered by recID if else not
specified.

> Of course I assume that Valentina always orders by RecID
> unless told to order by a different field, but since I have
> a generic function to create SQL statements, it produces
> such statements as above and ORDER BY RecID should
> not result in no records found in this case.
> 
> It does not throw an error, it simply doesn't return any records,
> so I think it might be a bug. What do you thing?

Yes this is a known glitch.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------