[doc] Method results

[Ruslan Zasukhin]

on 8/8/03 4:24, Erik Mueller-Harder at lists at praxisworks.com wrote:

Hi Erik,

> The Valentain Database Kernel manual states this (page 32):
> 
>   Method result can be of any supported Field type (except
>   BLOB types).
> 
> I have a VText field ("foo") that I want to render as lowercase, purely for
> case-insensitive searching purposes.
> 
> Just for the heck of it, I created a VText field ("bar") with the method
> "Lower(foo)".  It seems to work fine:  if I create a record in VAPP and
> populate foo, bar contains a lowercase version of it.
> 
> Is this supported?  Can I depend on it?  If not, would there be anything else
> I could do to achieve quick case-insensitive searching of a VText field that
> may often have more than 64KB (other than creating another field an populating
> it programmatically with a lowercase version of the same data -- I'd really
> rather not double my space requirements!)?

Yes, TEXT methods can work.
Although result - value of method is stored in RAM.
I.e. You cannot get 4GB text value in methods.

BTW, in 2.0 I will add flag fIndexCaseInsensetive,
So this will simplify life.

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