RE: Locking records in DB2

Joe,  

 

During update or insert time, we’ve found it necessary and advantageous to
loop through all fields for the some of the following reasons:

 

During update or insert, loop through the fields and: 

 

1.      Verify that if they are required, that there is a value in the field
2.      Is the current user authorized to update the field
3.      Is the value valid in terms of length and data type
4.      Is the value in the field valid in terms of the business object it
represents such as state, social security number, phone number, email
address, etc.  These are all common and generic tests.  
5.      Did the value change and therefore is an update needed in the first
place

 

How do you handle all these data and rule validations?  

 

We use JavaScript to catch as many checks as possible before hitting the
server but you also need to check server validation.  

Cycles can be important but processor speeds are ever increasing and
currently fast enough to make this a non issue.  We have this strategy
proven in dozens of applications.  

 

Programmer productivity, speed to market, and quality are important factors
for us.  

 

Paul Holm
Senior Web Architect
PlanetJ Corp. 
Phone: 760-432-0600, Cell: 760-415-8830
WOW, Web Applications In Under 5 Minutes
HYPERLINK "http://www.gotWebData.net"; \nhttp://www.gotWebData.net