Subject Character ' and applylocate some opinion would be welcome From Dirk <non@non.com> Date Wed, 6 Apr 2022 14:18:26 +0200 Newsgroups dbase.getting-started Hello i am playing around with Mastersource   as far all ok now i was a bit surprised about searching with applylocate for a name starting with a ' like 't veer got a an error when query without params when searchin for ' when query with an param : ' is accepted, see //   function Veld_Zoek_onKey(nChar, nPosition,bShift,bControl)      local cVeld       cVeld = "name = ' "+rtrim(+this.value)+" ' "          this.parent.vraagbak_klant.rowset.locateOptions = 3                 this.parent.vraagbak_klant.rowset.beginlocate()              this.parent.vraagbak_klant.rowset.ApplyLocate(cVeld)    //  this.parent.vraagbak_klant.params["letter"] = lower(ltrim(rtrim(this.value))+ "%")    //   this.parent.vraagbak_klant.requery()    //    this.parent.vraagbak_klant.rowset.first()    //     this.parent.Veld_zoek.setFocus() now when i use this function Veld_Zoek_onKey(nChar, nPosition,bShift,bControl)      local cVeld       //cVeld = "name = ' "+rtrim(+this.value)+" ' "         this.parent.vraagbak_klant.params["letter"] = lower(ltrim(rtrim(this.value))+ "%")        this.parent.vraagbak_klant.requery()        cVeld = "name = ' "+rtrim(+this.value)+" ' "       //   this.parent.vraagbak_klant.rowset.locateOptions = 3             //    this.parent.vraagbak_klant.rowset.beginlocate()              this.parent.vraagbak_klant.rowset.ApplyLocate(cVeld)            this.parent.vraagbak_klant.rowset.first() working aswell so i think the last function is doing the same once by requering and once by applylocate the point is how to use applylocate without param in the query and finding words starting with ' ( all others characters are accepted) thanks for some additional informatien, Dirk,