||Re: DBF level 4 to 7 Problem
||Tue, 14 Mar 2017 09:31:18 +0200
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.
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)