Re: [GENERAL] Sql Update Sentence

2009-05-23 Thread Martijn van Oosterhout
On Sat, May 23, 2009 at 03:13:58PM -0400, mariolos wrote: > hello to all!!! i have a quiestion and problem, i need replace a value from > a field with other value, i try using this sql sentence: > > update packing_acum set corr=corr + 200) BETWEEN 26821 AND 27340 and > extract(year from fec_prod)

Re: [GENERAL] Sql Update Sentence

2009-05-23 Thread Adrian Klaver
On Saturday 23 May 2009 12:13:58 pm mariolos wrote: > hello to all!!! i have a quiestion and problem, i need replace a value from > a field with other value, i try using this sql sentence: Is this the entire actual SQL statement? If so see below. > > update packing_acum set corr=corr + 200) BETWE

[GENERAL] Sql Update Sentence

2009-05-23 Thread mariolos
hello to all!!! i have a quiestion and problem, i need replace a value from a field with other value, i try using this sql sentence: update packing_acum set corr=corr + 200) BETWEEN 26821 AND 27340 and extract(year from fec_prod) = 2009 AND cod_packing between 2321 and 2327 but this error appear