>I am using CA for Insert/Update. I want to make the date fields NULL if user deletes a date. Can it be done without having to check each date field individually?
Yes,
Create a method in your CA base class, call it NullDate or whatever you want it as a name. In it put:
LPARAMETERS ldDatetime
RETURN IIF(EMPTY(ldDatetime), NULL, ldDatetime)
Then you must set ConversionFunc property of the CA for all Date or DateTime fields:
this.ConversionFunc = [DateField this.NullDate, DateTimeField this.NullDate]
that is all :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
