[doc] Method results

Erik Mueller-Harder lists at praxisworks.com
Thu Aug 7 21:24:19 CDT 2003


Hi, again, Ruslan --

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

Thanks for your guidance,

Erik


More information about the Valentina mailing list