ExecUpdate: Fail to add null value in not null attribute study_name
Is there any way around this error. Col1 is a not null field but col2 is not obviously since it is currently empty!
Thanks for the help.
Jodi
Bruno Wolff III wrote:
On Wed, Aug 20, 2003 at 10:16:38 -0400,
Jodi Kanter <jkanter@virginia.edu> wrote:
how do I copy from one field to another?
update tablename set newcol = oldcol;
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu