valentina, error with DISCTINCT

[Ruslan Zasukhin]

On 4/7/09 2:19 AM, "Christian - ChrisKatDev.com" <christian at chriskatdev.com>
wrote:

Hi Christian,

First of call can you download latest Vstudio
    http://www.valentina-db.com/download/beta/

And check this query against your db?


> Vs 3.6 : problem with distinct on varchar
> 
> This query doesn't work and returns a kernel error  (Kernel error: 0xffffffd9)
> :
> SELECT distinct nom FROM _type_couverture, _jonction_album  WHERE
> (_type_couverture.recID= idCouverture AND idPage = 2 AND idAlbum = 6 AND
> idReliure=2) 
> 
> BUT
> 
> This query works fine (except that I have same results several times)  :
> 
> SELECT nom FROM _type_couverture, _jonction_album  WHERE
> (_type_couverture.recID= idCouverture AND idPage = 2 AND idAlbum = 6 AND
> idReliure=2) 
> 
> 
> Field "nom" is varchar 128.
> 
> How can I get the distinct results ?



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