hi,
thanks ,
i don't need to make any delete or somthing else
just somthing as

for i= month12004 to month1212004
replace name2 with "wwwww"
replace name3 with "tttt"
replace name4 with "sssss"
<pre>
any idea,
yhanks.




>Usually, the best alternative is to have all the data, for different months and years, in a single table in the first place - precisely to make it easier to manipulate the data.
>
>You can write a small program to do all the REPLACEs, but then you will have the same problem over and over again, for DELETE, SELECT, etc., and under different conditions.
>
>>hi all,
>>i try  to do this code under,any new way..
>><pre>
>>USE month12004
>>LOCATE FOR no =1231
>>replace nam2 WITH "&#1589;&#1575;&#1604;&#1581;"
>>replace nam3 WITH "&#1575;&#1581;&#1605;&#1583;"
>>replace nam4 WITH "&#1575;&#1604;&#1605;&#1581;&#1605;&#1608;&#1583;"
>>
>>USE month22004
>>LOCATE FOR no =1231
>>replace nam2 WITH "&#1589;&#1575;&#1604;&#1581;"
>>replace nam3 WITH "&#1575;&#1581;&#1605;&#1583;"
>>replace nam4 WITH "&#1575;&#1604;&#1605;&#1581;&#1605;&#1608;&#1583;"
>>
>>USE month32004
>>LOCATE FOR no =1231
>>replace nam2 WITH "&#1589;&#1575;&#1604;&#1581;"
>>replace nam3 WITH "&#1575;&#1581;&#1605;&#1583;"
>>replace nam4 WITH "&#1575;&#1604;&#1605;&#1581;&#1605;&#1608;&#1583;"
>>
>>USE month42004
>>LOCATE FOR no =1231
>>replace nam2 WITH "&#1589;&#1575;&#1604;&#1581;"
>>replace nam3 WITH "&#1575;&#1581;&#1605;&#1583;"
>>replace nam4 WITH "&#1575;&#1604;&#1605;&#1581;&#1605;&#1608;&#1583;"
>>.
>>.
>>.
>>USE month122004
>>LOCATE FOR no =1231
>>replace nam2 WITH "&#1589;&#1575;&#1604;&#1581;"
>>replace nam3 WITH "&#1575;&#1581;&#1605;&#1583;"
>>replace nam4 WITH "&#1575;&#1604;&#1605;&#1581;&#1605;&#1608;&#1583;"
>>
>>

>>thanks