Subject function form_onNavigate(nWorkArea) From roy price <royprice@royprice.name> Date Mon, 10 May 2021 18:12:26 +1000 Newsgroups dbase.getting-started Amended to replace "character" for "text" This one's a mystery to me. My main table cactusaa, I have linked to a table Cactusaatext that contains a field "rec" that is the same as the "rec" field in the main table. The fields were Character 4ch, but I changed them to numeric, 4ch. this function (which I understand is the syntax for a numeric field) produces a "database engine error". function form_onNavigate(nWorkArea) this.cactusaatext1.rowset.applyLocate( "rec = " + this.cactusaa1.rowset.fields['rec'].value  ) But if I change it back to :- (Syntax for Character field) function form_onNavigate(nWorkArea)   this.cactusaatext1.rowset.applyLocate( "rec = '" + this.cactusaa1.rowset.fields['rec'].value+"'"  ) This worked OK when the field was Character, but now it still works, but only for when the contents of the field (4CH) are greater than "1000". IE, nothing under 1000 works. So I don't understand why the syntax for a Character field partially works, but the syntax for the correct numeric field does not. Do I understand the syntax correctly  for each field type? Regards Roy Price