Subject Re: [firebird-support] update all records
Author Michel LE CLEZIO
Post date 2016-05-05T19:55:54Z
Hello,

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 values...no ?

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,
Mikey


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


 
Thanks


On Wednesday, May 4, 2016 6:45 PM, "shg_sistemas@... [firebird-support]" <firebird-support@yahoogroups.com> 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

Thanks!!

Sergio