Subject Question about SQL errors
Author slsolutions2002
Hello:

I have been converting a lot of my Delphi database insert/undate/ etc
code and creating stored procedures. This has REALLY helped the
speed of my application. However, I started thinking about error
checking. If I have a routine that says:

If QueryTest.Locate('CUSTONERNO',CUSNO,[]) Then QueryTest.Edit ...
QueryTest.Post, I can generate an error if the QueryTest.Locate, and
get an error if the Post fails. In my stored procedure I say:

UPDATE TEST
SET xxx
WHERE CUSTOMERNO = :CUSNO

How can I tell if the record was updated ?

Thanks