# Table Fallback Enable selection missing?

**URL:** <https://forum.inductiveautomation.com/t/table-fallback-enable-selection-missing/18399>\
**Category:** Ignition\
**Created:** [June 11, 2018, 3:04pm UTC](https://forum.inductiveautomation.com/t/table-fallback-enable-selection-missing/18399 "2018-06-11T15:04:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasonpdavid](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@jasonpdavid](https://forum.inductiveautomation.com/u/jasonpdavid)\
**Post date:** [June 11, 2018, 3:04pm UTC](https://forum.inductiveautomation.com/t/table-fallback-enable-selection-missing/18399/1 "2018-06-11T15:04:52Z")

</div>

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.  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f320ad7725aebf662421687e2f8bc9a3d40e3f89.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 11, 2018, 3:09pm UTC](https://forum.inductiveautomation.com/t/table-fallback-enable-selection-missing/18399/2 "2018-06-11T15:09:24Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jasonpdavid](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@jasonpdavid](https://forum.inductiveautomation.com/u/jasonpdavid)\
**Post date:** [June 11, 2018, 3:17pm UTC](https://forum.inductiveautomation.com/t/table-fallback-enable-selection-missing/18399/3 "2018-06-11T15:17:44Z")

</div>

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…? 🙂

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 11, 2018, 3:19pm UTC](https://forum.inductiveautomation.com/t/table-fallback-enable-selection-missing/18399/4 "2018-06-11T15:19:42Z")

</div>

> [@jasonpdavid](#):
>
> Other that solve the connection loss issue...?

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

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [June 11, 2018, 3:27pm UTC](https://forum.inductiveautomation.com/t/table-fallback-enable-selection-missing/18399/5 "2018-06-11T15:27:00Z")

</div>

> [@jasonpdavid](#):
>
> That makes sense. Is there another way to prevent the popups on connection loss?

```auto
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!

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [June 11, 2018, 3:31pm UTC](https://forum.inductiveautomation.com/t/table-fallback-enable-selection-missing/18399/6 "2018-06-11T15:31:27Z")

</div>

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. 🙂