V4MD 4.5

[Christian - ChrisKatDev.com]

Le 19 févr. 2010 à 20:34, Ruslan Zasukhin a écrit :

> On 2/19/10 9:07 PM, "Ruslan Zasukhin" <ruslan_zasukhin at valentina-db.com>
> wrote:
> 
>> On 2/16/10 12:59 PM, "Christian - ChrisKatDev.com"
>> <christian at chriskatdev.com> wrote:
>> 
>>> Ruslan,
>>> 
>>> 
>>> this request with VS 4.5 :
>>> SELECT DISTINCT concat (width, "*", height) as 'dimensions' FROM _type_album,
>>> _jonction_album WHERE (activation = TRUE AND idAlbum = _type_album.recID)
>>> ORDER by _type_album.recID
>>> => crash
>>> 
>>> SELECT DISTINCT concat (width, height) as 'dimensions' FROM _type_album,
>>> _jonction_album WHERE (activation = TRUE AND idAlbum = _type_album.recID)
>>> ORDER by _type_album.recID
>>> => in progress... but without end
>> 
>> Hi Christian,
>> 
>> * I have start Vstudio 4.5 on MAC.
>> * Opened your db you have give us
>> 
>> * I have made query
>> 
>> SELECT DISTINCT concat (width, '*', height) as 'dimensions'
>> 
>> FROM _type_album, _jonction_album
>> 
>> WHERE (activation = TRUE AND idAlbum = _type_album.recID)
>> 
>> ORDER BY _type_album.recID
>> 
>> And I see 
>> ERROR: Field "0" not found.
> 
> This query returns the same 15 records without errors
> 
> SELECT DISTINCT _type_album.recID, concat (width, '*', height) as
> 'dimensions' 
> 
> FROM _type_album, _jonction_album 
> 
> WHERE (activation = TRUE AND idAlbum = _type_album.recID) 
> 
> ORDER BY _type_album.recID

this problem is a old problem, no ?
I remember this problem with Valentina 2, but not with 3 and after...

??

br
Christian
> 
> 
> -- 
> 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