[V4MD] Equivalent of V12's WordStarts operator?

[Ruslan Zasukhin]

On 9/29/08 9:39 PM, "Irv Kalb" <Irv at furrypants.com> wrote:

> (I also tried createVarCharField, and createTextField with the same
> results.  I tried setting the flags to[#fIndex, #fIndexByWords] but
> Valentina complained that this was an 'invalid type'.)
> 
> If I use Valentina Studio, I can see that this table was created and
> in the fields column it says:
> 
>    AuthorYearRefKeywords String[1536]:W
> 
> Does the W mean that it is set to be indexed by words?
> 
> 
> When I go to access the table, I build a query string like this:
> 
>   "SELECT AuthorYearRefKeywords FROM Biblio WHERE
> (left(AuthorYearRefKeywords,4) = 'Hays')"
> 
> It DOES find records that start with 'Hays' but does NOT find ones
> where those letters start a word (e.g, "James and Hays ... ").
> 
> 
> 
> I wanted to look at an example to see what I might be doing wrong, so
> I searched through all the documentation, and I found this:
> 
> http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documenta
> tion:examples:guide:api_style:api_style#indexbywords_example
> 
> but none of the examples (including the one on IndexByWords example)
> are clickable.

So check folder


    V4MD_3/Examples/API_way/IndexByWords.

Here I see line of code as

  fld_varChar = person.createVarCharField( "fld_varChar", 1022, [#fIndexed,
#fIndexByWords] )


Now compare to your code.

You have fIndex, must be fIndexed.




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]