V4MD problem with method

[Ruslan Zasukhin]

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

> Hi Ruslan,
> 
> I tried to do the method field with VarChar [6000] - that works in
> Director - but not with a really long text.
> So I tried it again with method field Text and as I said that doesn't
> work.
> I just cut off about 600 entries so there are only 19 entries.

Hi Henning,

I have test your db, and RESUME:

    BaseObject Method of TEXT type DO NOT work with LIKE search.
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


I recommend you simply to use INDEXED search.

1) set for field allFields flag IndexbyWords

2) do query as

    SELECT ...
    FROM T
    WHERE allFields = 'word1' or allFields = 'word2'

This search will be faster by the way.

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