continue on sql result error

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

Are you in a shiny App ?

Anyway, You could find this part of Advanced R useful about how to handle conditions

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