Sir, there is a cursor adapter named MASTER, that is on DataEnvironment.

I want to get values from cursoradapter to a cursor with this command

create CURSOR master1 (code  C(8),open_dr n(13,2),open_cr  n(13,2),desc1 c(30),;
	phone_o c(20),debit n(10,2),credit n(10,2),close_dr n(10,2),close_cr n(10,2))

select master1
append from dbf('master') for len(alltrim((code)))=7

But it shows this error message


Field CLOSE_CR does not accept null values.

(becuase close_cr has NULL value in original sqlserver table as shown in attached image)

My question is: how to get Null values as empty or zero into vfp cursors?
or someother solution to get rid of such error messages regarding Null values.