Bug with Select count(distinct)

[Ruslan Zasukhin]

On 3/23/04 10:52 PM, "James Milne" <james.milne at mac.com> wrote:

Hi James,

> Hi all,
> 
> I've had a problem with Valentina crashing when I perform the following
> operation:
> 
> select distinct( count shotIndex ) from take where sceneIndex = '1'

If I am not mistake must be

    select count( DISTINCT fld)

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------