Ellis Robin (Bundaberg) <[EMAIL PROTECTED]> wrote:
Thanks Igor, the records in the Parameter table are required to ensure that the values returned from NewParams are matched to the appropriate records.
They are matched to the record you are updating. SQLite walks all records in Parameter table, and for each record runs the subselect (the reference to Parameter table in the subselect represents the current row), then updates the field in the current row with the value thus calculated.
Read about coordinated subqueries in your favorite SQL textbook.
By removing the referenecs to Parameter in the FROm statement I achieve 0 updates.
Since you don't have a WHERE clause, every single record in the Parameter table is necessarily being updated. It is possible that the value calculated by the subselect for each record is equal to the current value in this record, so it appears that no update takes place. If this is unexpected, check the logic of your subselect.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
