valentina, error with DISCTINCT

[Christian - ChrisKatDev.com]

Hello,


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 ?


br
Christian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090407/09855d48/attachment.html