Subject Re: [firebird-support] update all records
Author Michel LE CLEZIO

I don't understand your SQL :
"Where 1=1"   first "1" is a field name ?

if "Where actualizar=1" it may works ?
The condition is on records, and must use fields ?

If you don't use condition, all records should be updated to the same value 0...

"Update stock set actualizar=0"  should update all records with actualizar =0 to whole stock table... 

With best regards,

Le Jeudi 5 mai 2016 19h19, "kristinwensley@... [firebird-support]" <> a écrit :


On Wednesday, May 4, 2016 6:45 PM, "shg_sistemas@... [firebird-support]" <> wrote:

hello! I've been googling but found nothing about it.

Why this sentence does not update all the records in the table? (FB 2.5)

update stock set actualizar = 0 where 1=1