Hi!
Use "_tally" system variable immediately after command executing to get number of records updated.
HTH.
>Dear all,
>
>Can I know how many records updated when I issued "UPDATE" sql statement? Thank you for your help and advice.
>
>Best Regards,
>
>Justy
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.