Subject Re: Field validation in grid From Milind Nighojkar <milinigh@yahoo.com> Date Tue, 10 Aug 2021 12:01:54 -0400 Newsgroups dbase.getting-started Thanks ken. Ken Mayer Wrote: > On 8/9/2021 11:08 AM, Milind Nighojkar wrote: > > Scenerio: > > I am in grid. > > I want to validate a field say a date field D1. Validation is D1 > date() with error message when cursor is leaving field or record. > > I want cursor to stay in filed till  feild value satisifies the validation condition > > > > Code is something like this > > function editorControl_onLostFocus() > >        local lRet > >        lRet = false > >        if this.value < date() > >         lRet = false // Allow cancel > >         this.validErrorMsg := "Past Date NOT allowed" > >         else > >         lRet = true > >         endif > > return lret > > > > > > Any suggestion ? > > > > I used various ways usingevents like onlostfocus,valid for field > > At row  level rowset_canEdit() > > > > You cannot put focus directly on the specific row/column of a grid. This > is a missing ability from the editorControl for the grid, and I believe > it has been posted as a bug report several times. > > I recommend not allowing editing in a grid. This is because it is much > harder to do things, such as what you're trying. Instead, provide a set > of controls above (below, to the side, whatever works for you) for the > current record, allow editing in those controls (datalinked to the > fields in the table), and when saved they changes will reflect in the > grid as well ... With the standard controls, you can allow the error > checking you're trying ... but not with the grid. > > Ken > > > -- > *Ken Mayer* > Ken's dBASE Page: http://www.goldenstag.net/dbase > The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp > dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm > dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm > dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm