Subject | Question about SQL errors |
---|---|
Author | slsolutions2002 |
Post date | 2002-02-19T21:19:41Z |
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
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