Table Fallback Enable selection missing?

Ignition
1

I am using Ignition 7.9.6 and I don’t see the Enable Fallback checkbox for the Table Data property. I am using a SQL Query and when the db connection drops I receive popup errors.

2

You can’t have a fallback when returning a dataset. A fallback is only available when returning a single value.

3

Thanks for the assistance. That makes sense. Is there another way to prevent the popups on connection loss? Other that solve the connection loss issue…? :slight_smile:

4

Not that I'm aware of. Ignition is pretty helpless without its database connections.

1 Like
5 
SELECT material_no as result		
From markers
where material_no clause here
ORDER BY tstamp DESC
UNION
SELECT '' as result	
From material
ORDER BY tstamp DESC

Here is some code I use for fallbacks in the MySQL query itself. I don't know if it can work with multiple selections. Good Luck!

1 Like
6

I just realized you said when the DB connection is lost, not when the query returns nothing back from the request. My post still might be helpful to someone down the road. :slight_smile:

1 Like