Index corruption on method field

[Steve Albin]

Hi Bart,

Thanks for your reply.  As it turns out, upgrading to version 5.5.1 fixes the problem.  I did not notice anything in the release notes indicating this, but it does work.  

I also tried cloning my database and that fixed the problem without upgrading to 5.5.1.  Somehow, my database was using UTF-16BE (maybe because it was created during the days of PPC?) and that was a problem.  I cloned the database to use UTF-16 and the index problem went away.

I still have to upgrade to 5.5.1 because there was an issue with cloning a UTF-16BE database that was fixed for 5.5.1.

But, all's well that ends well!

Steve

--
Steve Albin, Montclair, NJ
http://www.steve-albin.com
http://www.jazzdiscography.com

On Dec 30, 2013, at 3:16 AM, Bart Pietercil <bart.pietercil at cognosis.be> wrote:

> Hi Steve,
> 
> couple of things you might want to try:
> 
> 1) Does searching for LIKE ‘ZAS%’ produce a result?
> 2) (gutfeeling) What happens if you define your method as concat(upper(lname),’ ‘,upper(fname)) ?
> 
> hth
> 
> 
> 
> 
> — 
> Our office will be closed on:
> 24 (afternoon) - 25 - 31/12/2013 & 01/01/2014
> 
> Bart Pietercil
> Sent with aMac
> 
> On 27 Dec 2013 at 23:54:15, Steve Albin (steve at steve-albin.com) wrote:
> 
>> Using V4RB 5.3.4, I'm having problems updating a table and then doing a search for the record. 
>> 
>> My table is basically a list of just under 10,000 person names. I have an method field called UpName and it is indexed. The method is simple: Upper(Concat(lname, ' ' , fName)). lname and fname are varchar fields of 512 length. 
>> 
>> If I add a record with the last name low in the alphabet, it usually works fine. So, I add my name, "Steve Albin" and then do the following search: 
>> SELECT * FROM tblNames WHERE UpName LIKE 'alb%' 
>> 
>> This will work fine. But if I add a name with a higher letter in the alphabet, the search will not work. So, if I add "Ruslan Zasukhin" and then do this search: 
>> SELECT * FROM tblNames WHERE UpName LIKE 'zas%' 
>> 
>> the record will not be found. But once I reindex the database, the record will be found. 
>> 
>> I think my question is, what are things I could look for in my schema that may cause this. I don't think I've found some Valentina bug, but instead I may have implemented something incorrectly. Problem is, I can't see what. 
>> 
>> Maybe I should not use a method field for an index? I could create this field directly if I need to. 
>> 
>> Thanks for any ideas. 
>> 
>> Steve 
>> 
>> -- 
>> Steve Albin, Montclair, NJ 
>> http://www.steve-albin.com 
>> http://www.jazzdiscography.com 
>> 
>> _______________________________________________ 
>> Valentina mailing list 
>> Valentina at lists.macserve.net 
>> http://lists.macserve.net/mailman/listinfo/valentina 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131230/ea229249/attachment.html>