bob4423......
Resetting a code wont rectify an operating condition of the engine. If the engine has a fault with the CEL on, you can clear the code (CEL) but the fault will still be occuring. Once the ECU runs thru it's drive-cycle, it will light up the the CEL again. The DTC #P0123 is indicating an issue with the TPS....The TPS is affected by heat, humidity, carbon build-up, elctronic corrosion.... If you had the P0123 code and it went away, it just means that the ECU went thru another drive cycle and the trouble wasn't recognized again. Could be a sign that your TPS is on it's way out.....If you scan for codes again, you may or may not ger a DTC code, but you may get a "pending" code. If I were you, I would drive the vehicle as normal and if/when the CEL comes back on (after clearing it), scan the computer, if the P0123 code shows up again (at that time), I would clean the TPS unit, reset ECU, continue driving as normal and if the situation improves (ie: no more cel), I would plan on replacing the TPS......another thing, if your vehicle is idling erratically, I would disconnect, then reconnect.....one at a time....the TPS, the IAC, the MAP sensors.....to see which ones change's the characteristics of the idle.