Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace
Message
De
17/04/2008 03:21:45
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01311003
Message ID:
01311385
Vues:
23
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform