<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Yep, read it on the mantis reports (spoke to soon ;-))</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">OTOH I also find the changelog and release notes a bit… lacking ? It could be more outspoken on the issues that are fixed.</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Just my 2 €cent though</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Happy Newyear !</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Bart</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div> <div id="bloop_sign_1388410790815383040" class="bloop_sign"><span style="font-family:helvetica,arial;font-size:13px"></span>— <div><div apple-content-edited="true"><div style="font-family: Helvetica; font-size: medium; line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="margin: 0px; color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;"><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;"><b><i><u><span lang="EN-US" xml:lang="EN-US" style="font-size: 10pt; font-family: 'Century Gothic', sans-serif; color: red;">Our office will be closed on:</span></u></i></b></span></div><div style="margin: 0px; color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;"><b><i><span style="font-size: 10pt; font-family: 'Century Gothic', sans-serif; color: red;">24 (afternoon) - <a href="tel://25 - 31/12/2013">25 - 31/12/2013</a> & <a href="http://airmail.calendar/2014-01-01%2012:00:00%20GMT+1">01/01/2014</a></span></i></b></div></div></div></div></div></div><div><br>Bart Pietercil<br><span>Sent with aMac</span></div></div> <br><p style="color:#A0A0A8;">On 30 Dec 2013 at 14:39:14, Steve Albin (<a href="mailto://steve@steve-albin.com">steve@steve-albin.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>
<title></title>
Hi Bart,
<div><br></div>
<div>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. </div>
<div><br></div>
<div>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.</div>
<div><br></div>
<div>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.</div>
<div><br></div>
<div>But, all's well that ends well!</div>
<div><br></div>
<div>Steve</div>
<div><br>
<div apple-content-edited="true">
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'New York'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">
<font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica;">--</font></span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'New York'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">
<font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica;">Steve
Albin, Montclair, NJ</font></span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'New York'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">
<span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px;"><a href="http://www.steve-albin.com">http://www.steve-albin.com</a></span></span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;">
<a href="http://www.jazzdiscography.com"><font class="Apple-style-span" face="Helvetica">http://www.jazzdiscography.com</font></a></div>
</div>
<br>
<div>
<div>On Dec 30, 2013, at 3:16 AM, Bart Pietercil <<a href="mailto:bart.pietercil@cognosis.be">bart.pietercil@cognosis.be</a>>
wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div style="font-family: Helvetica, Arial; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">Hi
Steve,</div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">
<br></div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">
couple of things you might want to try:</div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">
<br></div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">1)
Does searching for LIKE ‘ZAS%’ produce a result?</div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">2)
(gutfeeling) What happens if you define your method as
concat(upper(lname),’ ‘,upper(fname)) ?</div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">
<br></div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">
hth</div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">
<br></div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">
<br></div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">
<br></div>
<div id="bloop_customfont" style="font-family: Helvetica, Arial; font-size: 13px; margin: 0px;">
<br></div>
<div id="bloop_sign_1388391139812281088" class="bloop_sign">—
<div>
<div apple-content-edited="true">
<div style="font-family: Helvetica; font-size: inherit; line-height: normal; orphans: 2; text-align: -webkit-auto; widows: 2; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin: 0px; color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;">
<span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;"><b><i><u><span lang="EN-US" xml:lang="EN-US" style="font-size: 10pt; font-family: 'Century Gothic', sans-serif; color: red;">
Our office will be closed on:</span></u></i></b></span></div>
<div style="margin: 0px; color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px;">
<b><i><span style="font-size: 10pt; font-family: 'Century Gothic', sans-serif; color: red;">
24 (afternoon) - <a href="tel://25%20-%2031/12/2013">25 -
31/12/2013</a> & <a href="http://airmail.calendar/2014-01-01%2012:00:00%20GMT+1">01/01/2014</a></span></i></b></div>
</div>
</div>
</div>
</div>
</div>
<div><br>
Bart Pietercil<br>
<span>Sent with aMac</span></div>
</div>
<br>
<p style="color: rgb(160, 160, 168);">On 27 Dec 2013 at 23:54:15,
Steve Albin (<a href="mailto://steve@steve-albin.com">steve@steve-albin.com</a>)
wrote:</p>
<blockquote type="cite" class="clean_bq"><span>Using V4RB 5.3.4,
I'm having problems updating a table and then doing a search for
the record. <br>
<br>
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. <br>
<br>
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: <br>
SELECT * FROM tblNames WHERE UpName LIKE 'alb%' <br>
<br>
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: <br>
SELECT * FROM tblNames WHERE UpName LIKE 'zas%' <br>
<br>
the record will not be found. But once I reindex the database, the
record will be found. <br>
<br>
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. <br>
<br>
Maybe I should not use a method field for an index? I could create
this field directly if I need to. <br>
<br>
Thanks for any ideas. <br>
<br>
Steve <br>
<br>
-- <br>
Steve Albin, Montclair, NJ <br>
<a href="http://www.steve-albin.com">http://www.steve-albin.com</a> <br>
http://www.jazzdiscography.com <br>
<br>
_______________________________________________ <br>
Valentina mailing list <br>
<a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a> <br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a> <br>
</span></blockquote>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a></div>
</blockquote>
</div>
<br></div>
_______________________________________________
<br>Valentina mailing list
<br>Valentina@lists.macserve.net
<br>http://lists.macserve.net/mailman/listinfo/valentina
<br></div></div></span></blockquote></body></html>