1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
ExecuterRequete('Article','Code',EditCritere1.text,
[
'UPDATE '+TableArticle[0]+' Set '+TableArticle[0]+'.'+ChampsArticle[0]+ ' = :Param1 Where ' + TableArticle[0] +'.' + ChampsArticle[0]+ ' = :Param2',
'UPDATE '+TableArticle[1]+' Set '+TableArticle[1]+'.'+ChampsArticle[1]+ ' = :Param1 Where ' + TableArticle[1] +'.' + ChampsArticle[1]+ ' = :Param2',
'UPDATE '+TableArticle[2]+' Set '+TableArticle[2]+'.'+ChampsArticle[2]+ ' = :Param1 Where ' + TableArticle[2] +'.' + ChampsArticle[2]+ ' = :Param2',
'UPDATE '+TableArticle[3]+' Set '+TableArticle[3]+'.'+ChampsArticle[3]+ ' = :Param1 Where ' + TableArticle[3] +'.' + ChampsArticle[3]+ ' = :Param2',
'UPDATE '+TableArticle[4]+' Set '+TableArticle[4]+'.'+ChampsArticle[4]+ ' = :Param1 Where ' + TableArticle[4] +'.' + ChampsArticle[4]+ ' = :Param2',
'UPDATE '+TableArticle[5]+' Set '+TableArticle[5]+'.'+ChampsArticle[5]+ ' = :Param1 Where ' + TableArticle[5] +'.' + ChampsArticle[5]+ ' = :Param2',
'UPDATE '+TableArticle[6]+' Set '+TableArticle[6]+'.'+ChampsArticle[6]+ ' = :Param1 Where ' + TableArticle[6] +'.' + ChampsArticle[6]+ ' = :Param2',
'UPDATE '+TableArticle[7]+' Set '+TableArticle[7]+'.'+ChampsArticle[7]+ ' = :Param1 Where ' + TableArticle[7] +'.' + ChampsArticle[7]+ ' = :Param2',
'UPDATE '+TableArticle[8]+' Set '+TableArticle[8]+'.'+ChampsArticle[8]+ ' = :Param1 Where ' + TableArticle[8] +'.' + ChampsArticle[8]+ ' = :Param2',
'UPDATE '+TableArticle[9]+' Set '+TableArticle[9]+'.'+ChampsArticle[9]+ ' = :Param1 Where ' + TableArticle[9] +'.' + ChampsArticle[9]+ ' = :Param2',
'UPDATE '+TableArticle[10]+' Set '+TableArticle[10]+'.'+ChampsArticle[10]+ ' = :Param1 Where ' + TableArticle[10] +'.' + ChampsArticle[10]+ ' = :Param2',
'UPDATE '+TableArticle[11]+' Set '+TableArticle[11]+'.'+ChampsArticle[11]+ ' = :Param1 Where ' + TableArticle[11] +'.' + ChampsArticle[11]+ ' = :Param2',
'UPDATE '+TableArticle[12]+' Set '+TableArticle[12]+'.'+ChampsArticle[12]+ ' = :Param1 Where ' + TableArticle[12] +'.' + ChampsArticle[12]+ ' = :Param2',
'UPDATE '+TableArticle[13]+' Set '+TableArticle[13]+'.'+ChampsArticle[13]+ ' = :Param1 Where ' + TableArticle[13] +'.' + ChampsArticle[13]+ ' = :Param2',
'UPDATE '+TableArticle[14]+' Set '+TableArticle[14]+'.'+ChampsArticle[14]+ ' = :Param1 Where ' + TableArticle[14] +'.' + ChampsArticle[14]+ ' = :Param2',
'UPDATE '+TableArticle[15]+' Set '+TableArticle[15]+'.'+ChampsArticle[15]+ ' = :Param1 Where ' + TableArticle[15] +'.' + ChampsArticle[15]+ ' = :Param2',
'UPDATE '+TableArticle[16]+' Set '+TableArticle[16]+'.'+ChampsArticle[16]+ ' = :Param1 Where ' + TableArticle[16] +'.' + ChampsArticle[16]+ ' = :Param2',
'UPDATE '+TableArticle[17]+' Set '+TableArticle[17]+'.'+ChampsArticle[17]+ ' = :Param1 Where ' + TableArticle[17] +'.' + ChampsArticle[17]+ ' = :Param2',
'UPDATE '+TableArticle[18]+' Set '+TableArticle[18]+'.'+ChampsArticle[18]+ ' = :Param1 Where ' + TableArticle[18] +'.' + ChampsArticle[18]+ ' = :Param2',
'UPDATE '+TableArticle[19]+' Set '+TableArticle[19]+'.'+ChampsArticle[19]+ ' = :Param1 Where ' + TableArticle[19] +'.' + ChampsArticle[19]+ ' = :Param2',
'UPDATE '+TableArticle[20]+' Set '+TableArticle[20]+'.'+ChampsArticle[20]+ ' = :Param1 Where ' + TableArticle[20] +'.' + ChampsArticle[20]+ ' = :Param2',
'UPDATE '+TableArticle[21]+' Set '+TableArticle[21]+'.'+ChampsArticle[21]+ ' = :Param1 Where ' + TableArticle[21] +'.' + ChampsArticle[21]+ ' = :Param2',
'UPDATE '+TableArticle[22]+' Set '+TableArticle[22]+'.'+ChampsArticle[22]+ ' = :Param1 Where ' + TableArticle[22] +'.' + ChampsArticle[22]+ ' = :Param2',
'UPDATE '+TableArticle[23]+' Set '+TableArticle[23]+'.'+ChampsArticle[23]+ ' = :Param1 Where ' + TableArticle[23] +'.' + ChampsArticle[23]+ ' = :Param2',
'UPDATE '+TableArticle[24]+' Set '+TableArticle[24]+'.'+ChampsArticle[24]+ ' = :Param1 Where ' + TableArticle[24] +'.' + ChampsArticle[24]+ ' = :Param2',
'UPDATE '+TableArticle[25]+' Set '+TableArticle[25]+'.'+ChampsArticle[25]+ ' = :Param1 Where ' + TableArticle[25] +'.' + ChampsArticle[25]+ ' = :Param2',
'UPDATE '+TableArticle[26]+' Set '+TableArticle[26]+'.'+ChampsArticle[26]+ ' = :Param1 Where ' + TableArticle[26] +'.' + ChampsArticle[26]+ ' = :Param2',
'UPDATE '+TableArticle[27]+' Set '+TableArticle[27]+'.'+ChampsArticle[27]+ ' = :Param1 Where ' + TableArticle[27] +'.' + ChampsArticle[27]+ ' = :Param2',
'UPDATE '+TableArticle[28]+' Set '+TableArticle[28]+'.'+ChampsArticle[28]+ ' = :Param1 Where ' + TableArticle[28] +'.' + ChampsArticle[28]+ ' = :Param2',
'UPDATE '+TableArticle[29]+' Set '+TableArticle[29]+'.'+ChampsArticle[29]+ ' = :Param1 Where ' + TableArticle[29] +'.' + ChampsArticle[29]+ ' = :Param2',
'UPDATE '+TableArticle[30]+' Set '+TableArticle[30]+'.'+ChampsArticle[30]+ ' = :Param1 Where ' + TableArticle[30] +'.' + ChampsArticle[30]+ ' = :Param2',
'UPDATE '+TableArticle[31]+' Set '+TableArticle[31]+'.'+ChampsArticle[31]+ ' = :Param1 Where ' + TableArticle[31] +'.' + ChampsArticle[31]+ ' = :Param2',
'UPDATE '+TableArticle[32]+' Set '+TableArticle[32]+'.'+ChampsArticle[32]+ ' = :Param1 Where ' + TableArticle[32] +'.' + ChampsArticle[32]+ ' = :Param2',
'UPDATE '+TableArticle[33]+' Set '+TableArticle[33]+'.'+ChampsArticle[33]+ ' = :Param1 Where ' + TableArticle[33] +'.' + ChampsArticle[33]+ ' = :Param2',
'UPDATE '+TableArticle[34]+' Set '+TableArticle[34]+'.'+ChampsArticle[34]+ ' = :Param1 Where ' + TableArticle[34] +'.' + ChampsArticle[34]+ ' = :Param2',
'UPDATE '+TableArticle[35]+' Set '+TableArticle[35]+'.'+ChampsArticle[35]+ ' = :Param1 Where ' + TableArticle[35] +'.' + ChampsArticle[35]+ ' = :Param2',
'UPDATE '+TableArticle[36]+' Set '+TableArticle[36]+'.'+ChampsArticle[36]+ ' = :Param1 Where ' + TableArticle[36] +'.' + ChampsArticle[36]+ ' = :Param2',
'UPDATE '+TableArticle[37]+' Set '+TableArticle[37]+'.'+ChampsArticle[37]+ ' = :Param1 Where ' + TableArticle[37] +'.' + ChampsArticle[37]+ ' = :Param2',
'UPDATE '+TableArticle[38]+' Set '+TableArticle[38]+'.'+ChampsArticle[38]+ ' = :Param1 Where ' + TableArticle[38] +'.' + ChampsArticle[38]+ ' = :Param2',
'UPDATE '+TableArticle[39]+' Set '+TableArticle[39]+'.'+ChampsArticle[39]+ ' = :Param1 Where ' + TableArticle[39] +'.' + ChampsArticle[39]+ ' = :Param2'
]); |
Partager