[V4MD] Equivalent of V12's WordStarts operator?

[Ruslan Zasukhin]

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

> I appreciate the help, but I'm still not getting this to work the right way.
> 
> I believe you that that the problem is with the indexing, but I don't
> know what I am doing wrong.  I am trying to build my table using
> INDEXBYWORDS.  This table is designed so that each record is just a
> single field which is a long string.  The code I am using to create
> the table is like this:
> 
> oTable = gDB.createTable(sTableName)  -- creates a reference to my
> table named 'sTable'
> ...
> oField = oTable.createStringField("AuthorYearRefKeywords", 1024,
> [#fIndexByWords]
> 
> curs = gDB.SqlSelect( "SELECT * FROM " & sTableName, #kClientSide, #kNoLocks )
> if CheckValError() then exit
> curs.ImportText(sFileName, TAB, RETURN, "UTF-8", TRUE)
> if CheckValError() then exit

Another hint.

Lingo of course is good, but faster testing is in Vstudio

* open db in Vstudio

* check that both IW are ON,
    if no click by mouse them both in the property inspector.

* now double click database in the second column
    this will open SQL Editor window

* copy paste or type here your query

        SELECT * FROM TableName

You will see result of query immediate.


Hmm, now I wonder, and what you want to see by this query?
    all records?




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