Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: null values for date fields from java


Message #1 by puppy1978@r... on Sat, 7 Apr 2001 11:57:22
hello p2p friends,

   I think this problem has no solution.but please try.

I have a  html form  in which we accept the request and give few actions.

requisition is done on a single attempt and hence no problem.but

each action will be filled  in different dates but  in the same form.



For example each action includes

  a) problem   	   textarea(html)             memo(ms access)

  b) action owner        	    textfield             	 text

  c)  email id           	     textfield               	 text

  d)  target date           	     textfield                   date/time

  e)implementation date      textfield                     date/time



it has more than ten actions.



  In many  cases the action owners may differ or even the single 

owner may fill the implementation dates in more than one attempt.here 

arises the problem.In MS-ACCESS we don't have provision to allow zero 

length for date.

so exception(ms-access driver datatype mismatch exception)  will be 

caught for null values of dates.  we can't  give default date there,

because when the form is opened next time for updation (or just for 

viewing)

the default implementation date will be displayed in the form which will 

make no sense.also handling these default dates for more than ten

fields is really complex.



   do you find any way to solve this problem?

Or atleast some better ideas?

if so please help.

Eagerly awaiting the reply,

--bye from priya.

  


  Return to Index