Look at TIB_Query.OnValidateRow event that's perfectly working for field based validation and TIB_Query.OnBeforePost event for row based validation. Call "abort" to avoid posting.

Look at TIB_Query.FieldDefaultValues to avoid annoying message "This is a required field".

Mit freundlichem Gruss & Best Regards & Happy New Year

Andreas Pohl
apohl@...
www.ibp-consult.com

> So,what event should i use to do row level validations.