title: I need to update two fields; one is dependent on the other
body: <p>Here is what I want to work, but I don't know that the sequence of actions will make it work correctly:</p>
  <p>UPDATE table SET field1 = field1 + 1,field2 = field3 * field1</p>
  <p>After adding 1 to field1, use this new value to relace field2 with the calculation field3 * field1</p>
  <p>It looks good but I don't know if (1) the first update will be the &quot;first&quot; update, and (2) whether the calculation in the second update will pick up the new, incremented field1 value.</p>
  <p>I suppose another option would be:</p>
  <p>UPDATE table SET field1 = field1 + 1,field2 = field3 * ( field1 + 1 )</p>
  <p>But this assumes that field1 is NOT updated before the calculation in the second update is made.</p>
  <p>IDEAS?????</p>