[V4MD] method field

[Ruslan Zasukhin]

on 4/20/03 10:32 AM, Henning Pertiet at valentina at pertiet.de wrote:

> Hi Ruslan,
> 
>> I do not understand what is your problem.
> 
> Of course not because I didn't explain my problem. Thought I would
> find it myself - but I don't.
> 
>> Method works not correctly ?
> 
> Exactly.
> Let my try to explain:
> 
> I created a database (sometime ago already) where I have for example
> the following:
> field: bearb VarChar 25
> field: titel VarChar 504
> field: text  Text    1024
> field: rtftext  Text 1024
> ...
> (now I changed the Text properties in VAPP, when I delete the entry it
> automatically
> puts 128 into the field segmentsize)
> 
> And I have a method field: allfields CONCAT(bearb,titel,text)
> At first I put VarChar 504
> 
> Now in my application I have this sql for searching:
> 
> vSQL = "SELECT DSID,bearb,titel,text FROM berichte  WHERE \
> (allfields  LIKE '" &sstringA&"' no_case) AND \
> (allfields LIKE '" &sstringB&"'  no_case) AND \
> (allfields LIKE '" &sstringC&"'  no_case) ORDER BY titel "
> 
> What I didn't notice is that - for example - a word at the end of a
> long text would not be found.

And this is obvious.

You have forget to add SPACE between fields in your CONCAT:
More correct is:

            CONCAT(bearb,' ', titel, ' ', text)

> Now I tried to change the fields propertys to :
> allfields Text 128
> 
> But that doesn't work. (VISQL crashes and in DIR I get an error at
> when I try to access the cursor)

Yes, if I am not mistake, BaseObject Method cannot be TEXT for now.


> Sorry if these problems might sound primitive but I really don't
> understand

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