Append from dbf('csrMyCursor') for !empty(csrMyCursor.bookno) and !empty(csrMyCursor.sticket);
 and !empty(csrMyCursor.eticket)

Add more fields if necessary!

>hi,
>this is the fields.
>

>Select bookno,sticket,eticket,NOOFTICKET,BOXNO,shipno,trans_type from trans1 into cursor csrmyCursor readwrite where .F.
>SELECT csrMyCursor
>With thisform.Grid1
>  .RecordSource = "csrMyCursor"
>  .Columncount = 7
>  .Column1.ControlSource = "csrMyCursor.bookno"
>  .Column2.ControlSource = "csrMyCursor.sticket"
>  .Column3.ControlSource = "csrMyCursor.eticket"
>  .Column4.ControlSource = "csrMyCursor.noofticket"
>  .Column5.ControlSource = "csrMyCursor.boxno"
>  .Column6.ControlSource = "csrMyCursor.shipno"
>.Column7.ControlSource = "csrMyCursor.trans_type"
>    append blank
>  .Refresh()
>ENDWITH
>
>

>>I am sure that you don't have a FIELD called bookno.sticket.eticket in your csrCourse cursor???
>>
>>>hi,
>>>thank you,
>>>i try as under, but still take the empty records
>>>

>>>   Append from dbf('csrMyCursor') for !empty('csrMyCursor.bookno.sticket.eticket')
>>>

>>>
>>>thanks
>>>
>>>
>>>>Append from dbf('csrCourse') for !empty(csrCourse.somefield) && Replace somefield with a real field name!
>>>>
>>>>>hi all,
>>>>>any idea,help
>>>>>
>>>>>i need to append at my table only records not empty from my grid1(csrCourse)
>>>>>
>>>>>APPEND FROM (DBF("csrCourse"))&& only record!empty
>>>>>
>>>>>thanks