Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Only a General Database Exception for Missing Field in Stored Procedure.
Mon, Jun 12 2017 6:40 PMPermanent Link

Steve Gill

Avatar

Hi Tim,

If a stored procedure is called that doesn't have a field that the client app is expecting, only a general EDatabase exception is raised.  There is no EEDBError exception.

Would it be possible to add an exception for this so that I can test for it?

For example:

    if (EEDBError(E).ErrorCode = EDB_FIELD_NOT_FOUND) then

Thanks.

= Steve
Tue, Jun 13 2017 12:30 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Steve,

<< If a stored procedure is called that doesn't have a field that the client app is expecting, only a general EDatabase exception is raised.  There is no EEDBError exception.

Would it be possible to add an exception for this so that I can test for it? >>

This is handled at the TDataSet layer, which is why you're seeing a general EDatabaseError instead of a specific EEDBError exception.

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Jun 13 2017 5:25 PMPermanent Link

Steve Gill

Avatar

<< This is handled at the TDataSet layer, which is why you're seeing a general EDatabaseError instead of a specific EEDBError exception. >>

Ok, thanks Tim.  I've done a workaround by parsing E.Message.

= Steve
Image