I think you have 2 options: 1. normalize the table to have 2 fields "Month Number" & "Month Value", then you can search record by "Month Number" for updating "Month Value"
2. use PSQL statement: EXECUTE STATEMENT, you can read about it in Firebird-2.5-LangRef-Update.pdf --- In [email protected], "Softtech Support" <stwizard@...> wrote: > > In Delphi I have the ability to reference a field using FieldByName() inside > a For loop like this: > > For I := 1 to 120 do > begin > with cdsReport do > begin > FieldByName('MONTH_' + IntToStr(I)).Visible := iNoOfCols >= I; > end; > end; > > > Is there any way to do this in a Firebird Stored Procedure? I have 120 > fields named MONTH_1 thru MONTH_120 and currently I have to reference them > like this. Just wanting to know if there is a better way.. > ... > I = 1; > > WHILE (I <= iNoOfColumns ) DO > BEGIN > IF (I = 1) THEN > MONTH_1 = MONTH_1 + nTotalMonth; > ELSE IF (I = 2) THEN > MONTH_2 = MONTH_2 + nTotalMonth; > ELSE IF (I = 3) THEN > MONTH_3 = MONTH_3 + nTotalMonth; > ELSE IF (I = 4) THEN > MONTH_4 = MONTH_4 + nTotalMonth; > ELSE IF (I = 5) THEN > MONTH_5 = MONTH_5 + nTotalMonth; > ELSE IF (I = 6) THEN > MONTH_6 = MONTH_6 + nTotalMonth; > ELSE IF (I = 7) THEN > MONTH_7 = MONTH_7 + nTotalMonth; > ELSE IF (I = 8) THEN > MONTH_8 = MONTH_8 + nTotalMonth; > ELSE IF (I = 9) THEN > MONTH_9 = MONTH_9 + nTotalMonth; > ELSE IF (I = 10) THEN > MONTH_10 = MONTH_10 + nTotalMonth; > ELSE IF (I = 11) THEN > MONTH_11 = MONTH_11 + nTotalMonth; > ELSE IF (I = 12) THEN > MONTH_12 = MONTH_12 + nTotalMonth; > ELSE IF (I = 13) THEN > MONTH_13 = MONTH_13 + nTotalMonth; > ELSE IF (I = 14) THEN > MONTH_14 = MONTH_14 + nTotalMonth; > ELSE IF (I = 15) THEN > MONTH_15 = MONTH_15 + nTotalMonth; > ELSE IF (I = 16) THEN > MONTH_16 = MONTH_16 + nTotalMonth; > ELSE IF (I = 17) THEN > MONTH_17 = MONTH_17 + nTotalMonth; > ELSE IF (I = 18) THEN > MONTH_18 = MONTH_18 + nTotalMonth; > ELSE IF (I = 19) THEN > MONTH_19 = MONTH_19 + nTotalMonth; > ELSE IF (I = 20) THEN > MONTH_20 = MONTH_20 + nTotalMonth; > ELSE IF (I = 21) THEN > MONTH_21 = MONTH_21 + nTotalMonth; > ELSE IF (I = 22) THEN > MONTH_22 = MONTH_22 + nTotalMonth; > ELSE IF (I = 23) THEN > MONTH_23 = MONTH_23 + nTotalMonth; > ELSE IF (I = 24) THEN > MONTH_24 = MONTH_24 + nTotalMonth; > ELSE IF (I = 25) THEN > MONTH_25 = MONTH_25 + nTotalMonth; > ELSE IF (I = 26) THEN > MONTH_26 = MONTH_26 + nTotalMonth; > ELSE IF (I = 27) THEN > MONTH_27 = MONTH_27 + nTotalMonth; > ELSE IF (I = 28) THEN > MONTH_28 = MONTH_28 + nTotalMonth; > ELSE IF (I = 29) THEN > MONTH_29 = MONTH_29 + nTotalMonth; > ELSE IF (I = 30) THEN > MONTH_30 = MONTH_30 + nTotalMonth; > ELSE IF (I = 31) THEN > MONTH_31 = MONTH_31 + nTotalMonth; > ELSE IF (I = 32) THEN > MONTH_32 = MONTH_32 + nTotalMonth; > ELSE IF (I = 33) THEN > MONTH_33 = MONTH_33 + nTotalMonth; > ELSE IF (I = 34) THEN > MONTH_34 = MONTH_34 + nTotalMonth; > ELSE IF (I = 35) THEN > MONTH_35 = MONTH_35 + nTotalMonth; > ELSE IF (I = 36) THEN > MONTH_36 = MONTH_36 + nTotalMonth; > ELSE IF (I = 37) THEN > MONTH_37 = MONTH_37 + nTotalMonth; > ELSE IF (I = 38) THEN > MONTH_38 = MONTH_38 + nTotalMonth; > ELSE IF (I = 39) THEN > MONTH_39 = MONTH_39 + nTotalMonth; > ELSE IF (I = 40) THEN > MONTH_40 = MONTH_40 + nTotalMonth; > ELSE IF (I = 41) THEN > MONTH_41 = MONTH_41 + nTotalMonth; > ELSE IF (I = 42) THEN > MONTH_42 = MONTH_42 + nTotalMonth; > ELSE IF (I = 43) THEN > MONTH_43 = MONTH_43 + nTotalMonth; > ELSE IF (I = 44) THEN > MONTH_44 = MONTH_44 + nTotalMonth; > ELSE IF (I = 45) THEN > MONTH_45 = MONTH_45 + nTotalMonth; > ELSE IF (I = 46) THEN > MONTH_46 = MONTH_46 + nTotalMonth; > ELSE IF (I = 47) THEN > MONTH_47 = MONTH_47 + nTotalMonth; > ELSE IF (I = 48) THEN > MONTH_48 = MONTH_48 + nTotalMonth; > ELSE IF (I = 49) THEN > MONTH_49 = MONTH_49 + nTotalMonth; > ELSE IF (I = 50) THEN > MONTH_50 = MONTH_50 + nTotalMonth; > ELSE IF (I = 51) THEN > MONTH_51 = MONTH_51 + nTotalMonth; > ELSE IF (I = 52) THEN > MONTH_52 = MONTH_52 + nTotalMonth; > ELSE IF (I = 53) THEN > MONTH_53 = MONTH_53 + nTotalMonth; > ELSE IF (I = 54) THEN > MONTH_54 = MONTH_54 + nTotalMonth; > ELSE IF (I = 55) THEN > MONTH_55 = MONTH_55 + nTotalMonth; > ELSE IF (I = 56) THEN > MONTH_56 = MONTH_56 + nTotalMonth; > ELSE IF (I = 57) THEN > MONTH_57 = MONTH_57 + nTotalMonth; > ELSE IF (I = 58) THEN > MONTH_58 = MONTH_58 + nTotalMonth; > ELSE IF (I = 59) THEN > MONTH_59 = MONTH_59 + nTotalMonth; > ELSE IF (I = 60) THEN > MONTH_60 = MONTH_60 + nTotalMonth; > ELSE IF (I = 61) THEN > MONTH_61 = MONTH_61 + nTotalMonth; > ELSE IF (I = 62) THEN > MONTH_62 = MONTH_62 + nTotalMonth; > ELSE IF (I = 63) THEN > MONTH_63 = MONTH_63 + nTotalMonth; > ELSE IF (I = 64) THEN > MONTH_64 = MONTH_64 + nTotalMonth; > ELSE IF (I = 65) THEN > MONTH_65 = MONTH_65 + nTotalMonth; > ELSE IF (I = 65) THEN > MONTH_66 = MONTH_66 + nTotalMonth; > ELSE IF (I = 67) THEN > MONTH_67 = MONTH_67 + nTotalMonth; > ELSE IF (I = 68) THEN > MONTH_68 = MONTH_68 + nTotalMonth; > ELSE IF (I = 69) THEN > MONTH_69 = MONTH_69 + nTotalMonth; > ELSE IF (I = 70) THEN > MONTH_70 = MONTH_70 + nTotalMonth; > ELSE IF (I = 71) THEN > MONTH_71 = MONTH_71 + nTotalMonth; > ELSE IF (I = 72) THEN > MONTH_72 = MONTH_72 + nTotalMonth; > ELSE IF (I = 73) THEN > MONTH_73 = MONTH_73 + nTotalMonth; > ELSE IF (I = 74) THEN > MONTH_74 = MONTH_74 + nTotalMonth; > ELSE IF (I = 75) THEN > MONTH_75 = MONTH_75 + nTotalMonth; > ELSE IF (I = 76) THEN > MONTH_76 = MONTH_76 + nTotalMonth; > ELSE IF (I = 77) THEN > MONTH_77 = MONTH_77 + nTotalMonth; > ELSE IF (I = 78) THEN > MONTH_78 = MONTH_78 + nTotalMonth; > ELSE IF (I = 79) THEN > MONTH_79 = MONTH_79 + nTotalMonth; > ELSE IF (I = 80) THEN > MONTH_80 = MONTH_80 + nTotalMonth; > ELSE IF (I = 81) THEN > MONTH_81 = MONTH_81 + nTotalMonth; > ELSE IF (I = 82) THEN > MONTH_82 = MONTH_82 + nTotalMonth; > ELSE IF (I = 83) THEN > MONTH_83 = MONTH_83 + nTotalMonth; > ELSE IF (I = 84) THEN > MONTH_84 = MONTH_84 + nTotalMonth; > ELSE IF (I = 85) THEN > MONTH_85 = MONTH_85 + nTotalMonth; > ELSE IF (I = 86) THEN > MONTH_86 = MONTH_86 + nTotalMonth; > ELSE IF (I = 87) THEN > MONTH_87 = MONTH_87 + nTotalMonth; > ELSE IF (I = 88) THEN > MONTH_88 = MONTH_88 + nTotalMonth; > ELSE IF (I = 89) THEN > MONTH_89 = MONTH_89 + nTotalMonth; > ELSE IF (I = 90) THEN > MONTH_90 = MONTH_90 + nTotalMonth; > ELSE IF (I = 91) THEN > MONTH_91 = MONTH_91 + nTotalMonth; > ELSE IF (I = 92) THEN > MONTH_92 = MONTH_92 + nTotalMonth; > ELSE IF (I = 93) THEN > MONTH_93 = MONTH_93 + nTotalMonth; > ELSE IF (I = 94) THEN > MONTH_94 = MONTH_94 + nTotalMonth; > ELSE IF (I = 95) THEN > MONTH_95 = MONTH_95 + nTotalMonth; > ELSE IF (I = 96) THEN > MONTH_96 = MONTH_96 + nTotalMonth; > ELSE IF (I = 97) THEN > MONTH_97 = MONTH_97 + nTotalMonth; > ELSE IF (I = 98) THEN > MONTH_98 = MONTH_98 + nTotalMonth; > ELSE IF (I = 99) THEN > MONTH_99 = MONTH_99 + nTotalMonth; > ELSE IF (I = 100) THEN > MONTH_100 = MONTH_100 + nTotalMonth; > ELSE IF (I = 101) THEN > MONTH_101 = MONTH_101 + nTotalMonth; > ELSE IF (I = 102) THEN > MONTH_102 = MONTH_102 + nTotalMonth; > ELSE IF (I = 103) THEN > MONTH_103 = MONTH_103 + nTotalMonth; > ELSE IF (I = 104) THEN > MONTH_104 = MONTH_104 + nTotalMonth; > ELSE IF (I = 105) THEN > MONTH_105 = MONTH_105 + nTotalMonth; > ELSE IF (I = 106) THEN > MONTH_106 = MONTH_106 + nTotalMonth; > ELSE IF (I = 107) THEN > MONTH_107 = MONTH_107 + nTotalMonth; > ELSE IF (I = 108) THEN > MONTH_108 = MONTH_108 + nTotalMonth; > ELSE IF (I = 109) THEN > MONTH_109 = MONTH_109 + nTotalMonth; > ELSE IF (I = 110) THEN > MONTH_110 = MONTH_110 + nTotalMonth; > ELSE IF (I = 111) THEN > MONTH_111 = MONTH_111 + nTotalMonth; > ELSE IF (I = 112) THEN > MONTH_112 = MONTH_112 + nTotalMonth; > ELSE IF (I = 113) THEN > MONTH_113 = MONTH_113 + nTotalMonth; > ELSE IF (I = 114) THEN > MONTH_114 = MONTH_114 + nTotalMonth; > ELSE IF (I = 115) THEN > MONTH_115 = MONTH_115 + nTotalMonth; > ELSE IF (I = 116) THEN > MONTH_116 = MONTH_116 + nTotalMonth; > ELSE IF (I = 117) THEN > MONTH_117 = MONTH_117 + nTotalMonth; > ELSE IF (I = 118) THEN > MONTH_118 = MONTH_118 + nTotalMonth; > ELSE IF (I = 119) THEN > MONTH_119 = MONTH_119 + nTotalMonth; > ELSE IF (I = 120) THEN > MONTH_120 = MONTH_120 + nTotalMonth; > END > > I = I + 1; > ... > > Thanks to all that can lend any insight, > Mike > > > [Non-text portions of this message have been removed] >
