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..
>
>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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
