Exception Handling with DB express

729 Views Asked by At

I am migrating our application from BDE to DBexpress in Delphi2010.We are connecting to Sybase Database.

The exceptions raised by stored procedure using raiseerror message was getting captured by BDE but the same is not happening with DBexpress.

Eg the stored proc contains the below statement if any validation fails

select @msg = "Could not perform the edit because another user has changed the record "

if @field1 <> @field2 raiserror 20999 @msg return end

Is there any way to catch this exception with DB express.

or Is it a bug in dbexpress?

Thanks!

1

There are 1 best solutions below

0
On