Index corruption on method field

[Bart Pietercil]

Yep, read it on the mantis reports (spoke to soon ;-))

OTOH I also find the changelog and release notes a bit… lacking ? It could be more outspoken on the issues that are fixed.
Just my 2 €cent though


Happy Newyear !

Bart

— 
Our office will be closed on:
24 (afternoon) - 25 - 31/12/2013 & 01/01/2014

Bart Pietercil
Sent with aMac

On 30 Dec 2013 at 14:39:14, Steve Albin (steve at steve-albin.com) wrote:

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

_______________________________________________  
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/08f80f31/attachment-0001.html>