I'm sorry, I don't understand what you want to do. Please explain in more detail.
>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
