Help Update does not work allt the time

[PatBlais]

Hello,

Does anyone know about this problem? Update with a simple set does not work...the click on compile does nothing

Update Wynstagn.All_G
SET All_Desc = 'X';

But if i add a select in the update...it worked

Update Wynstagn.All_G
SET All_G.desc = (SELECT DISTINCT code FROM All_G WHERE code = 'M1')

thx ina dvance

Pat

 

[PatBlais]

oups

I typed a mistake.

The is Update Wynstagn.All_G
SET All_G.desc = 'X';