Corrupt index

[Ivan Smahin]

On 6/20/2011 1:52 PM, Beatrix Willius wrote:
> Hi Ivan,
>
> cleaning data means changing it. One example is straightening quotes with a simple regex:
>
>    dim theRegex as new regex
>    theRegex.options.ReplaceAllMatches = true
>    theRegex.searchpattern = "«|»|“|”|‹|›|„"
>    theRegex.replacementPattern = """"
>    theString = theRegex.replace(theString)
>
> TheString in this case is the field MessageBody. This is then written to the database
>
>      theCleaner.setString theCursor.Field("MessageBody").GetString
>      theCursor.Field("MessageBody").SetString theCleaner.execute
>      theCursor.UpdateRecord
>
> And somewhere here the index is corrupted.
>

Can you send us some db and app to reproduce the problem?

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com