valentina, error with DISCTINCT

[Christian - ChrisKatDev.com]

Le 7 avr. 09 à 08:07, Ruslan Zasukhin a écrit :

> On 4/7/09 2:19 AM, "Christian - ChrisKatDev.com" <christian at chriskatdev.com 
> >
> wrote:
>
> Hi Christian,
Hi Ruslan,
>
>
> First of call can you download latest Vstudio
>    http://www.valentina-db.com/download/beta/

no, verion 4 have a big problem when you dump database (xml or sql) :  
you dont have "return" in file
this xml (or sql) are impossible to read !!
I continue with 3.6

>
>
> And check this query against your db?

after several tests, it's appear that after make field indexed and  
reindex all database ad field, it's ok now...
???
distinct dont work with no indexed field ?

br
Christian
>
>
>
>> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina