FDX query throws an exception error when empty.

JoBo
New Contributor

Hi, I'm currently using a FDX query to create an automated Journal. Works basically fine but when the FDX query is completely empty it throws an exception error message. Not a very big deal but the users experience this as a failure of the system. Does someone know a way to avoid this throw or to customize the exception error message in case of an empty datatable?

FYI a check on the datatable (f (Not dt Is Nothing) And (dt.Rows.count > 0) Then) still gives the throw.

 

Thanks!

 

1 REPLY 1

JackLacava
Community Manager
Community Manager

Hard to say without looking at the code or the error, but did you try just surrounding the guilty call with a try/catch block...? So that you can then ignore the exception.