easier than your commands :
select [fieldlist] from master where len(alltrim((code)))=7 into cursor master1 readwrite
if you need specific columns without NULL, massage that column into the wanted result
or do later 1 sweep of the whole cursor fixing unwanted elements
if you want to learn cursoradapter (reccommended!) do it the cursoradapter way, specifying fieldlist and other properties
>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.