Forum Discussion

JoBo's avatar
JoBo
New Contributor
3 years ago

FDX query throws an exception error when empty.

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!

 

Admin
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    3 years ago

    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.