Hi Michael,

> We have a program made in D5 using standard D5 comp. with BDE (and
> yes I know we should switch away from BDE, but the time isn't there
> right now !).
> We use FB 1.03.
> It runs on a Windows 2000 server.
>
> Every once in a while some of my customers complains about a
> difference between some values in the system.
> I have been looking into the problem, and at this point I suspect my
> program to sometimes do an update on a table, but the row I would
> like to update doesn't exists (because I think I gives over a wrong
> parameter to my query, but I'm not sure).
> Such an update just doesn't do anything since the row doesn't exists.
>
> Can I after an update has been performed tell if there has been an
> update or not ?
> If I could I could tell my customer (in my program) that there didn't
> happen any updates, but there should have been !

If you're updating from the client side - with an UPDATE <table> etc,
you can check the Query component "AffectedRows" or "RowsAffected"
property (cannot remember the exact name, but you get the idea).


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com