[V4MD] method field

[Ruslan Zasukhin]

on 4/20/03 12:49 PM, Henning Pertiet at valentina at pertiet.de wrote:

>>> I remember the tool DebugView - is there any difference in the
>>> Debug-output to the normal output in DIR's message window?
> 
>> No difference!
>> And you can switch output.
> 
>> Just note, if Director crashes, then better to use DbgView,
>> Because after crash of Director it still alive and you can see messages.
> 
> 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.

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------