7
Views
1
Comments
[Advance Query] Error on empty result from ExecuteSelect
Forge component by Paulo Fagundes Jr.
12
Published on 20 Dec 2019
Application Type
Traditional Web

Hello,

I would like to ask if someone already had this issue or not with this component.

I have a case that a select can return an empty list, and the component returns the following error: "Object of type 'System.DBNull' cannot be converted to type 'System.String'."

Don't know if this is something that could be resolved outside the extension or not.

Thank you!

Hi!

 If that's a expected situation you can treat it in the "Exception Handler" of the action   

The "If" verifies if the Database Exception is not the one you described, in that case let your "UserException1"

 behave like the normal exceptions, if is the error ""Object of type 'System.DBNull' cannot be converted to type 'System.String'."  the action continues the process. 

Hope the idea helps 

Graça