Problem with select

[Ruslan Zasukhin]

On 28/10/07 9:14 PM, "Joseph Morgan" <joseph at checkos.com> wrote:

> 
>> Is there a reason, why you choose "Text"? Text is for large "blob"
>> style fields, while VarChar is propitiate for "common" "text-fields"
> 
> Hmmm. Change all fields to VarChar and now the select works.
> Not sure why it would matter. But it does.
> 
> Could this be a bug? Or you think it is valentina designed intentional?

For TEXT fields that search also must work.

You did not answer on my advice to REINDEX db.

During CHANGE TYPE - Valentina could re-index field.
    so this can be double effect.

Just for interest you can try change that field to TEXT again and see if it
start to works.


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