<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;">Hi Steve,</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;">couple of things you might want to try:</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;">1) Does searching for LIKE ‘ZAS%’ produce a result?</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;">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; 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;">hth</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;"><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_sign_1388391139812281088" 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 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><div><div>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>http://www.steve-albin.com
<br>http://www.jazzdiscography.com
<br>
<br>_______________________________________________
<br>Valentina mailing list
<br>Valentina@lists.macserve.net
<br>http://lists.macserve.net/mailman/listinfo/valentina
<br></div></div></span></blockquote></body></html>