I'm using v6.5. I found out accidentally that the query: <p>update table set field = value' where key =
keyvalue; --notice the accidental tick <p>silently ignores everything after the tick and does not generate any
kindof syntax error. <br />This quietly clobbered a table by updating the field in every record in the table. (The
where<br />clause was ignored.) <p>The tick shouldn't have been there, it was just a typing error. But unless I'm
missingsomething, <br />it seems like it would be good to generate an error like "Unmatched quotes" or some such thing.
<pre>--
----------------------------------------------------
Kyle Bateman President, Action Target Inc.
"Viva Yo!" kyle@actarg.com (801)377-8033x101
----------------------------------------------------</pre>