>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.
SET NULL ON, so that the cursor gets created with fields that accept nulls. OR specifically allow nulls in the relevant fields in the CREATE CURSOR command.
Tamar