In addition you should look at the BeforeRowColChange and AfterRowColChange events and RowColChange property.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Rafael Copquin Sent: Tuesday, October 29, 2013 2:20 PM To: [email protected] Subject: Re: Grid Column References You should take a look at the sequence of events. In a textbox it goes like this: when-gotfocus-keypress-valid-lostfocus. I have a little form that shows you in what order events fire, which I can send to you if you want. You should program your validation code in the textboxes of the columns. When you move away from the current row, the valid event of the textbox fires and if it succeds, control goes to the lostfocus event In order to control what to do when there is success or failure, you should return 1 (to jump to the next control, passing first through the lostfocus method) or 0 if you want the user to stay on the textbox. example textbox init this.addproperty('lValid',.t.) textbox valid ** this code lets you close the form or avoid validation if you click on the x at the right hand corner of the form ** works in conjunction with the keypress event if lastkey() = 27 or empty(this.value) escape key or mouse click pressed this.lValid = .f. endif if lValid if this.value = your control code if successful return 1 go directly to the lostfocus event and run the code there else pop an error message return 0 user will only leave this control if valid code is introduced or escape key is pressed endif endif keypress event LPARAMETERS nKeyCode, nShiftAltCtrl if nKeyCode = 27 release thisform endif lostfocus event if this lValid run whatever code if validation succeds else this.lValid = .t. && reset this property's value endif The above is the basic, but you can complicate it a little bit more, by adding: textbox valid if lastkey() = 27 or empty(this.value) or lastkey() = 28 escape key or mouse click or F10 pressed this.lValid = .f. endif keypress event LPARAMETERS nKeyCode, nShiftAltCtrl if nKeyCode = 27 release thisform endif if nKeyCode = 28 call a lookup form to consult a price list for instance endif Rafael Copquin El 29/10/2013 14:50, Gene Wirchenko escribió: > Dear Vixens and Reynards: > > What is the best way to define a fixed reference to a column? > > When the operator tries to move away from the current row, I want > the current control's validation to be done, and if that succeeds, > then the row-level validation to be done. If the row-level validation > fails, I want to set the focus on the first (measuring from the left) > applicable control. > > The issue: Gird's .ActiveColumn is according to the physical > order which may have changed from the start because columns can be put > in a different order. > > An example from my app is the following validation rule: > basicchg+ovrhdfee=dsbamt+xsvamt If the columns were still in > that order, the row-level validation failing, the focus should go to > the basicchg control. If the order were changed to, say, > dsbamt xsvamt basicchg ovrhdfee then the focus should go > to the dsbamt control. How do I find out which control is the > leftmost? > > Suppose I just want the basicchg control to get the focus. How do > I figure out its .ActiveColumn (or do an equivalent thing) so that I > can .setFocus() appropriately. > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD044228ED0906F@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
