>VFP9 is giving me a FIELD UPDATE DOES NOT ACCEPT NULL VALUES. How can I fix this?
>
>
>

>		INSERT INTO obn_temp (name, obligor, obligation, unit,;
>			property, subdivsn, lot,;
>			oldavail, avail,;
>			complete, update, flags, disb_date, ;
>			disb_amt, run_total, dda_ind, dda_no) VALUES ;
>			(rapobn.name, rapobn.obligor, rapobn.obligation, rapobn.unit,;
>			m.prop_desc, rapobn.subdivsn, rapobn.lot,;
>			rapobn.avail2disb, rapobn.avail2disb,;
>			rapobn.prcntcmplt, m.dlstchg, m.flags, DATE(), ;
>			0.00, 0.00, bankcntl.dda_def, rapobn.disb_ddano)
>

INSERT INTO obn_temp (name,;          && 1
                      obligor,;       && 2
                      obligation,;    && 3
                      unit,;          && 4
		      property,;      && 5
                      subdivsn,;      && 6
                      lot,;           && 7
		      oldavail,;      && 8
                      avail,;         && 9
		      complete,;      && 10
                      update,;        && 11
                      flags,;         && 12
                      disb_date, ;    && 13
		      disb_amt,;      && 14
                      run_total,;     && 15
                      dda_ind,;       && 16
                      dda_no) VALUES ;  && 17
                     (rapobn.name,;                 && 1
                      rapobn.obligor,;              && 2
                      rapobn.obligation,;           && 3
                      rapobn.unit,;                 && 4
		      m.prop_desc,;                 && 5
                      rapobn.subdivsn,;             && 6
                      rapobn.lot,;                  && 7
		      rapobn.avail2disb,;           && 8
                      rapobn.avail2disb,;           && 9
		      rapobn.prcntcmplt,;           && 10
                      m.dlstchg,;                   && 11
                      m.flags,;                     && 12
                      DATE(), ;                     && 13
		      0.00,;                        && 14
                      0.00,;                        && 15
                      bankcntl.dda_def,;            && 16
                      rapobn.disb_ddano)            && 17

Check why m.dlstchg is null, or just put NVL(m.dlstchg, some_value_according_to_type_of_update_field) in INSERT INTO command