Subject Re: function form_onNavigate(nWorkArea) From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 10 May 2021 15:30:32 +0530 Newsgroups dbase.getting-started Good Afternoon Roy, This is in addition to what Mervyn has said. > The fields were text 4ch, but I changed them to numeric, 4ch. Is there an index to this field. If yes then please check the expression and preferably delete and recreate it. The index is probably stuck with character field type. Regards Akshat > > 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 text field) > > function form_onNavigate(nWorkArea) >   this.cactusaatext1.rowset.applyLocate( "rec = '" + > this.cactusaa1.rowset.fields['rec'].value+"'"  ) > > > This worked OK when the field was text, but now it still works, but only > for when the contents of the field (4CH) are greater than "1000". IE, > nothing under 1000 works.