thank you
but field wark from mstr table
i need to replace mstr.wark with mycur.wark from grid1

&& about zap i need to do that every month

&& NB! mean what:)

thanks for advance


>Your code is diffuse, so I can only guess here....
>

select payroll
>zap
>append from dbf('mycur')&& ok
>
>******************************
>***no errors no result
>SCAN
>   M.EMP=payroll.employeeid && mycur must be wrong??
>   M.MARK1=payroll.WARK
>   Update mstr set mark=m.mark1 where no=m.emp && SQL is easier and often quicker
>ENDSCAN
><\pre>
>
>NB! Once again: you should NEVER zap a table on a regular basis, only during maintainance a few times per year. If you need to zap regularly, you must rethink your design. Usually you should use a cursor instead of a table in such cases.
>
>
>>hi all,
>>any help to active this code
>>
>>

>>select payroll
>>zap
>>append from dbf('mycur')&& ok
>>
>>******************************
>>***no errors no result
>>SCAN
>>   M.EMP=mycur.employeeid
>>   M.MARK1=mycur.WARK
>>   replace MSTR.wark WITH M.MARK1 FOR MSTR.NO =M.EMP
>>ENDSCAN
>><\pre>
>>thanks