V4MD 4.5

[Ruslan Zasukhin]

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


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