SQLExec(handle,"insert into pubs.dbo.authors "+; " (au_id,au_fname,au_lname)"+; " values "+; " ('999-99-1234','Test','Name')") * would fail * Phone and Contract doesn't accept NULL and only phone has default value SQLExec(handle,"insert into pubs.dbo.authors "+; " (au_id,au_fname,au_lname,contract)"+; " values "+; " ('999-99-1234','Test','Name',1)") *would succeed *Same with UpdatenameList and UpdatableFieldlistCetin