Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace
Message
From
17/04/2008 03:21:45
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01311003
Message ID:
01311385
Views:
22
thank you very much,
it works.
update Mstr set Wark = myCur.Wark from Mstr inner join MyCur on Mstr.No = myCur.Emp
>>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
>>
>>thanks
>
>Don't use REPLACE FOR condition in the SCAN LOOP
>
>If you want to update one table based on another use UPDATE command, something like
>
>update Mstr set Wark = myCur.Wark from Mstr inner join MyCur on Mstr.No = myCur.Emp
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform