thank you very much ,
it works .


>

>Select * from payroll into cursor mycur readwrite where .f.

>
>>yes,
>>i mean how i can create empty cursor,the fields as payroll.dbf
>>thanks
>>
>>>I don't understand, do you have more questions?
>>>
>>>>thank you for reply,
>>>>
>>>>an empty curgrid cursor must be created in the form's load event.
>>>>
>>>>as select fields form payroll into cursor curgrid.but it is not empty
>>>>thanks
>>>>
>>>>
>>>>>I must confess that I don't exactly understand your question, but I guess this is what you eally want

>>>>>Select *something* into cursor mycur readwrite
>>>>>Select curgrid && the cursor which "drives" your grid
>>>>>zap
>>>>>append from dbf('mycur')
>>>>>thisform.grid1.refresh()

>>>>>For this to work, an empty curgrid cursor must be created in the form's load event.
>>>>>
>>>>>>hi all,
>>>>>>
>>>>>>is there away to replace all fields (from talias1.payroll) i have at mygrid ,to my talias1.payroll
>>>>>>
>>>>>>thanks
>>>>>>

>>>>>>SET DELETED  on
>>>>>>SELECT TAlias1.employeeid,TAlias2.nam,TAlias2.nam4,TAlias1.workdays,TAlias1.absencewp,TAlias1.absencew,TAlias1.uovertimeh,TAlias1.whovertime,TAlias1.vacations,TAlias1.sickvacati,TAlias2.wark  ;
>>>>>> FROM payroll TAlias1, mstr TAlias2 ;
>>>>>> WHERE  TAlias1.employeeid = TAlias2.no ;
>>>>>>  ORDER BY employeeid ;
>>>>>>  INTO cursor  mycur readwrite
>>>>>>
>>>>>>      thisform.Grid1.RecordSource=" mycur"
>>>>>>         thisform.Grid1.refresh()
>>>>>>
>>>>>>