Select command using right

[Ruslan Zasukhin]

on 2/19/03 2:14 AM, Yennie at aol.com at Yennie at aol.com wrote:

> To clarify... do you mean you cannot use left() or right() in SELECT at all
> now, even if the field is a method? i.e., you must have the functions
> built-in to the method?

Brian, only LEFT() can be used for now.
 
IF the field is method then OF COURSE this method can be used in SELECT,
And indirectly its functions.

> If so, this should probably be documented with a big warning. I for one have
> a bunch of code (which luckily I don't use anymore) that collects search
> terms and uses left() to search the database, i.e.:
> 
> SELECT * FROM MyTable WHERE left(SEARCH_TEXT, "&length(searchTerm)&") = "&
> searchTerm

THIS WORKS

Because I have add left() even before of functions.
Because this open access to fast indexed search.

In the same time RIGHT() will not do indexed search.

> SEARCH_TEXT is a method indexed by words which collects all of the text
> fields from the record.
> 
> So I used a method, but I still used left() in the SELECT statement. It works
> as a pretty fast, basic search engine! Is this not supported in current
> version?
> 
> Note- I don't need this anymore (I use a separate search engine), but it
> could bite some others?
> 
> Brian
> 
>> 1) you get nothing because you CANNOT use functions directly in SELECT
>> For current Valentina version.
>> You need use BaseObject methods for this.

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