Bug with Select count(distinct)

[Ruslan Zasukhin]

On 3/24/04 2:31 AM, "James Milne" <james.milne at mac.com> wrote:

>>> Is there anything missing from my column definitions which might be
>>> causing
>>> the above SQL query to crash? For instance, am I missing some sort of
>>> NULL
>>> behaviour criteria from the column constraints?
>> 
>> I do not think so.
>> 
>> Only IndexByWords make field NOT SORTABLE.
> 
> That's OK, the only field I would want to index by words is the comment
> field, and I don't sort on it.
> 
> Anyhow, is IndexByWords supported in V4RB 1.10?

Yes, James.

It Is supported. I mean that if you index by words some string fields, you
cannot sort on it.

To be able sort, you should create second index on this field, using helper
BaseObject method without flag IndexbyWords

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