Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace at many tables
Message
De
11/02/2005 06:19:59
 
 
À
11/02/2005 05:11:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 5
Database:
Visual FoxPro
Divers
Thread ID:
00985784
Message ID:
00985908
Vues:
16
hi,
thank you so much,it works
best regards.
m.qasem
>Usually the simplest and also very often the fastes solution is SQL:
>
>FOR numberofmonth = 1 to 12
>  myvar = "month"+ALLTRIM(STR(numberofmonth))+"2004"
>  UPDATE (myvar) set name2="صالح",;
>    name3="احمد", name4="المحمود";
>    where no=1231
>ENDFOR
>
>>hi all,
>>i try to do this code under,any new way..
>>
>>USE month12004
>>LOCATE FOR no =1231
>>replace nam2 WITH "صالح"
>>replace nam3 WITH "احمد"
>>replace nam4 WITH "المحمود"
>>
>>USE month22004
>>LOCATE FOR no =1231
>>replace nam2 WITH "صالح"
>>replace nam3 WITH "احمد"
>>replace nam4 WITH "المحمود"
>>
>>USE month32004
>>LOCATE FOR no =1231
>>replace nam2 WITH "صالح"
>>replace nam3 WITH "احمد"
>>replace nam4 WITH "المحمود"
>>
>>USE month42004
>>LOCATE FOR no =1231
>>replace nam2 WITH "صالح"
>>replace nam3 WITH "احمد"
>>replace nam4 WITH "المحمود"
>>.
>>.
>>.
>>USE month122004
>>LOCATE FOR no =1231
>>replace nam2 WITH "صالح"
>>replace nam3 WITH "احمد"
>>replace nam4 WITH "المحمود"
>>
>>
>>thanks
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform