Information on error on TIBCScrpit/TIBCQuery

calou · Post by **calou** » Fri 11 Mar 2011 14:48

Hello,

How to get information from a TIBCScript or a TIBCQuery when it makes exceptions(bad SQL), not just the error message, but the other information such as table name and primary key value?

Thanks for help

Regards

AndreyZ · Post by **AndreyZ** » Mon 14 Mar 2011 10:54

Hello,

Such errors are server-side and IBDAC returns them in the error message. Therefore you can find this information only in the error message. You can use the Message, ErrorCode, ErrorNumber, and SQLErrorMsg properties of the EIBCError class to get more information about the error you've got. For more information about the EIBCError class, please read the IBDAC documentation.