help: update row number

Hi, all When I run a update sql in dbaccess, occur a strange things: select count(*) from tab1 where <condition>, it return about 1200 rows. but using the same condition, update tab1 set field1=** where <condition>, everytime it only update129 rows. I don't know why? Thanks a lot.

Pl. run UPDATE STATISTICS which should solve the discrepancies. lily wrote: > Hi, all > > When I run a update sql in dbaccess, occur a strange things: > select count(*) from tab1 where <condition>, it return about 1200 rows. > but using the same condition, > update tab1 set field1=** where <condition>, everytime it only update> 129 rows. > I don't know why? > > Thanks a lot.