Re: field validation (was Re: COBOL/DB2 Date edit question)

LX-i wrote:
Frank Swarbrick wrote:

This brings to mind an interesting issue that we've been struggling
with for years at our shop. This issue being, where does input
validation belong?

Our system had it in several places. The date/time procedure I've
mentioned before (P315) had validation on every routine in it. We'd
have programs that validated screen input, then passed it to a batch
program that re-validates the same input. While that may seem
wasteful, it is of note that the batch program could be run without
going through the screen.

When we put a GUI front-end, there were even more edits that happen on
it, before the page is even submitted! But, again, there are ways to
script things that don't go through the GUI, so a program can't assume
that the input has been validated before.

You can't have too much data validation. Even, as you say, when the data had
presumbably already been validated.

One wonders how much code was recently written to check previously checked
dates for Y2K...


.

Relevant Pages

  • Re: Whats the difference between PF created by SQL and PF created by DDS?
    ... Different validation - especially for decimal data - is performed by DB2 depending on whether the table was created via SQL or DDS. ... UNIQUE key validation is not identical to data validation. ...
    (comp.sys.ibm.as400.misc)
  • Re: Combo Box
    ... When you show the properties window to show change the .matchentry property, ... "Dave Peterson" wrote: ... the data validation, i use it for the drop down list. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Combo Box
    ... the data validation, i use it for the drop down list. ... i highlight the cells that i want for the dropdown list, data, validation, ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Combo Box
    ... the data validation, i use it for the drop down list. ... i highlight the cells that i want for the dropdown list, data, validation, ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: field validation (was Re: COBOL/DB2 Date edit question)
    ... mentioned before had validation on every routine in it. ... programs that validated screen input, then passed it to a batch program ... note that the batch program could be run without going through the screen. ... When we put a GUI front-end, there were even more edits that happen on it, ...
    (comp.lang.cobol)