Re: [Squirrel-sql-users] A wrong SQL Update statement and Squirrel detect it, but still the first part of SQL statement is being executed

[John H. <jh...@im...>]

On Thu, 12 Jan 2012, Gerd Wagner wrote:

> On 12.01.2012 23:00, John Hardin wrote:
>>  On Thu, 12 Jan 2012, Paulus Gunawan wrote:
>> 
>> >  UPDATE TABLE_A WHERE STATUS = 'X';
>>
>>  That seems to be an incomplete UPDATE statement (no SET clause).
>>
>>  What SQL engine accepted that query as valid? What is it supposed to do?
> 
> I copied the statement from Paulus's mail quoted below. The statement is not 
> correct SQL syntax but from the context of the original mail the statement is 
> good enough to make sense in its context.
>
> But you are right, it would have been clearer if I had written
>
> UPDATE TABLE_A ... WHERE STATUS = 'X'>

Okay. I was wondering if that is what was meant.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   The United States has become a place where entertainers and
   professional athletes are mistaken for people of importance.
                                         -- Maureen Johnson Smith Long
-----------------------------------------------------------------------
  4 days until Benjamin Franklin's 306th Birthday