Re: invoking the After-field checks
Posted in 1995
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
Calvin Ng (calvinng@technet.sg) wrote: : I apologise if this appears in the manual, cos I don't have the manual : with me. : One of my client has written a 4GL program that uses arrays. : There is a field that has a AFTER FIELD clause that performs validation, : as well as updates the other fields in the same row. : This works fine until the user starts using arrow keys to leave that : particular field. The after field clause is not invoked. : So, what can be done now? : I can think of two approach but don't know how to implement them. : ONE) be able to intercept the ARROW keys and the PAGE-UP and PAGE-DOWN keys, : and do the validation thorugh the ON KEY clause. Is it possible? : TWO) to use the AFTER ROW clause for checking. This will perform the : validation, but will leave the user at the wrong row. Example, if : he uses the UP or DOWN arrow to leave the field, he will either be above : or below the record with error. Worst case is if he uses PAGE-UP or : PAGE-DOWN keys to leave the field. : Thus, after checking, I need the mechanism to move back to the row : that I just left, ie the row that contains error. How do one do that? To the best of my knowledge and experience, the "after field" clause is called REGARDLESS of how you leave the field (return,tab,arrow,PgUp,PgDown) with the exception of hitting the INTERRUPT key. This means you can be assured that your "after field" will always be processed. I don't know any reasons why you may be experiencing something other than this, unless there was a version that had a bug related to this?? -- Dale Van Voorst voorst@dordt.edu Computer Services postmaster@dordt.edu Dordt College Sioux Center, IA 51250 (712) 722-6299