dbaccess updated rows
Posted in 2009
Hallo,
if I run in dbacces an update statement with an condition, dbaccess
shows me how many rows are updated.
But now I have an demand to run an sql script with about 8000 update
statements
....
UPDATE fyar1sta Set Kunde=3 Where Sa=0 and Artikel ='00045858-0200 ';
UPDATE fyar1sta Set Kunde=5 Where Sa=0 and Artikel ='00045865-0200 ';
UPDATE fyar1sta Set Kunde=45 Where Sa=0 and Artikel ='00045872-0200 ';
...
The scrip rund without an error and if I look in differtent records I
can see, that the field Kunde is updated.
But dbacces didt shown me at the end of the script, how many rows are
updatet.
It only shows me :
1 row(s) updated
So I can not verify if all rows of the script are updated.
Greetings
Ralf