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.