Refresh table content when no data found from service connection
Content
I have made a service connection through OIC that connected a DB to run a SQL to get result.
And made some parameters to filter the data.
In VBCS, I created inputText accosiated with the parameters to get the result like [select * from table where columnA = parameterA]....
When I input some parameters that result had sevral lines returned from OIC, there is no problem.
But, when I input some wrong value into the parameter and no data had found from OIC, last query result remained in the table.
When I set the default value to the inputText(with the default value, no data can be retrived from OIC), [No data to Display.] can be shown in the table.
Tagged:
0