Watch Out For The SQL Delete Function
The SQL DELETE clause sometimes refers to a single column, but don't assume that field's value is the only one being deleted. The SQL DELETE clause deletes an entire record--it makes no difference if the
clause references only a single field. For example:
- DELETE FROM tblMyStuff WHERE Flag = True;
- DELETE FROM tblMyStuff.OrderID WHERE Flag = True;
The above two SQL DELETE commands both do exactly the same thing, they both delete the entire record. Specifing the field such as OrderID does no good, the entire record will still be deleted. So remember, when the SQL DELETE function is used, the entire record will be deleted.
Just click on the button for the Tiproom's Home Page.
Date of last revision: 17 August 2001.