DesignersTalk - View Single Post

LazyMoon · 31-05-2007, 06:27

The UPDATE command (as far as I remember) wont throw an error if it is trying to update a row (as selected by the WHERE clause) when no such row exists in the table.

Say for example, trying to update row #45 when there is no row with an ID of 45.

Also, I highly recommend you wrap all the field names in "`" to make it easier to distinguish between field names and other data.

31-05-2007, 06:27	#6 (permalink)
LazyMoon Registered Join Date: Sep 2006 Location: Adelaide, Australia Posts: 12	The UPDATE command (as far as I remember) wont throw an error if it is trying to update a row (as selected by the WHERE clause) when no such row exists in the table. Say for example, trying to update row #45 when there is no row with an ID of 45. Also, I highly recommend you wrap all the field names in "`" to make it easier to distinguish between field names and other data.