[V4MD] method field

[Henning Pertiet]

Sonntag, 20. April 2003  12:33 you wrote:


>> In my case its not Director that crashes but Visql.
>> In Director when I try to get records it gives back an error 5 (which
>> I think is access denied - a windows error message)
>> Now I am completely confused...
>> (Should I search for some eggs first?)

> All this is strange.

> So once again,

> You have 

> field: bearb VarChar 25
> field: title VarChar 504
> field: text  Text    1024

> And you do method field:
>     allfields CONCAT(bearb,' ', title, ' ', text) as TEXT.
        
> Have you try to make it as VarChar[60000] ?
> Does crash go away?

> And you do LIKE search...
> May be, try to make allFields to be indexed by words and use Indexed search.

> Send me your database with few records if still problems.

I'll try your suggestions first and let you know - but this will be
tommorow I think.


-- 
Best Regards
Henning Pertiet
mailto:valentina at pertiet.de