Subject Re: function form_onNavigate(nWorkArea) From Mervyn Bick <invalid@invalid.invalid> Date Mon, 10 May 2021 15:53:33 +0200 Newsgroups dbase.getting-started On 2021/05/10 15:24, Mervyn Bick wrote: >> The field is indexed and named "rec". I deleted the index saved the >> table, and then recreated it, to no avail. > > What is the index expression used to create the index? > >> I'm confused as to why the syntax for a character field works for >> records containing numbers that are over 1000, but not those under >> 1000. Should it not work at all? > > It's working for four character values because these don't need padding > to fill the field.  There is, therefore, no problem finding the > corresponding value in the second table. > > It's not working for 1, 2 and 3 character values because the rec fields > in the two tables are not padded in exactly the same way. Some more thoughts on this.  The contents of the rec field itself should not be padded at all.  If you have padded the contents it can be removed quite easily. use cactusaa replace all rec with ltrim(rec) use use cactusaatext replace all rec with ltrim(rec) use Recreate the index use cactusaa exclu index on right(space(4)+trim(rec),4) tag rec //or whatever you named the index use use cactusaatext exclu index on right(space(4)+trim(rec),4) tag rec //or whatever you named the index use Mervyn.