Bug with Select count(distinct)

[James Milne]

On 23 Mar, 2004, at 21:47, Ruslan Zasukhin wrote:

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

Actually- I should have proof-read my email.

The query is actually

select count( distinct shotIndex ) from take where sceneIndex = '1'

--
James Milne