[V4MD] method field

[Henning Pertiet]

Hi Ruslan,


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


What exactly is the difference here?


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


Alright, I see...
But what is the sense of what you wrote on Oct 23, 2002:
(I noticed that you wrote: no many sense...)

>> But I wonder if it is possible (or if it makes sense) to use a TEXT field
>> within CONCAT?
>>
>> If it does how do I make The FieldAll-Field?
>> Like this:
>> "FieldAll", TEXT, 1024, "German", " CONCAT(f1,f2,...,f18" )

>Yes you can do this. But I think no many sense.

>Note that you can have fieldAll as varChar,
>But f1 - f18 fields can be combination of string, Varchar and Text fields.

So, when I have a field Text within CONCAT it is being cut when the
VarChar of allfields runs out of space? Is that correct?

If so the only solution would be NOT to use Text but VarChar - but how
do I know how much text (maximum) would fit into a VarChar ?

  Regards

  Henning



-- 

Henning Pertiet
mailto:valentina at pertiet.de