Thanks to David Basic solution is to use triggers Eg Re: Using a table with a date field as a control date

Jim m wrote: > David > Coould you be a little more specific, or give a little more direction > where to look. > I am using Informix forms not 4GL > > Thanks, Jim CREATE PROCEDURE sp_check_date (Pi_date_enter DATE) DEFINE l_ar_date DATE; LET l_ar_date = (SELECT ar_close_date FROM ar_cntrl ); IF (Pi_date_enter <= l_ar_date) THEN RAISE EXCEPTION -746, 0, "date enter < " || l_ar_date; END IF; END PROCEDURE; { create database trigger to control adding new records with date <= ar control date } CREATE TRIGGER inscerte_addINSERT ON inscerte REFERENCING NEW AS inscerte_new FOR EACH ROW (EXECUTE PROCEDURE sp_check_date (inscerte_new.date_enter)) Preliminary testing of these works quite nicely In INFORMIIX FORMS . Am testing what effect it mught have on other applications that might do multiple updates.