continue on sql result error

shiny
1

Hi
I can successfully retrieve data using
dbFetch(dbSendQuery(con, paste0("SELECT * FROM Table1 .....

If I perform the same query for a date period which is before the queried date (aka records don't exist) I retrieve an error and the app crashes

is there a way to avoid the crash and instead create a message saying "no data found"

Thanks
Patrick

2

Are you in a shiny App ?

Anyway, You could find this part of Advanced R useful about how to handle conditions
https://adv-r.hadley.nz/conditions.html#handling-conditions

3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.