Subject Re: DBF level 4 to 7 Problem From WJS <warra@nowhere.com> Date Tue, 14 Mar 2017 09:31:18 +0200 Newsgroups dbase.getting-started On 2017/03/13 11:19 PM, Peter wrote: > ...... > Thank your both for your quick responses. > About a year ago I changed another dbf from level 4 to 7, and got messed up math with a numeric field becoming null instead of zero.  Mervyn saved the day with a short and highly effective program to replace a numeric field with a null value to 0.00.  Will give it a try.  Certainly sounds like that is the problem. > Will report back. > Peter > Don't know Mervyn's solution but just FWIW: You can also use local sql directly e.g. update <tableName> set <fieldName1> = <value>, <fieldName2> = <value> where (<fieldName> IS NULL OR <fieldName2> IS NULL) Wian