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



--
"I used to write COBOL...now I can do anything."
"LX-i" <lxi0007@xxxxxxxxxxxx> wrote in message
news:iO2dnbe7vsZjpVzbnZ2dnUVZ_jydnZ2d@xxxxxxxxxxxxxx
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.


All of which makes "encapsulated back end validation" (stored procedures and
triggers) just that bit more appealing.

Pete.
--
"I used to write COBOL...now I can do anything."


.

Relevant Pages

  • Re: field validation (was Re: COBOL/DB2 Date edit question)
    ... mentioned before 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. ... When we put a GUI front-end, there were even more edits that happen on it, before the page is even submitted! ... A man who believes in a God he doesn't see, ...
    (comp.lang.cobol)
  • can this be done
    ... I have a batch program written in C#, that reads a text file, does some ... validation on the fields in the text file. ... So my question is, is it possible to have Biztalk read the text file, ... Prev by Date: ...
    (microsoft.public.biztalk.general)
  • Re: field validation (was Re: COBOL/DB2 Date edit question)
    ... mentioned before had validation on every routine in it. ... it is of note that the batch program could be run without ... When we put a GUI front-end, there were even more edits that happen on ... You can't have too much data validation. ...
    (comp.lang.cobol)