# Perspective table strange behavior

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-strange-behavior/60027>\
**Category:** Ignition\
**Tags:** perspective, ignition81\
**Created:** [May 25, 2022, 6:47pm UTC](https://forum.inductiveautomation.com/t/perspective-table-strange-behavior/60027 "2022-05-25T18:47:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gaurav.Shitole](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/gaurav.shitole/32/72050_2.png) [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\
**Post date:** [May 25, 2022, 6:47pm UTC](https://forum.inductiveautomation.com/t/perspective-table-strange-behavior/60027/1 "2022-05-25T18:47:04Z")

</div>

Hello there,

I’m facing strange issue with perspective table component.

I’ve a table component with data bind to sql query. Table has a event editCellCommit that when I update/add new row to the table it inserts/updates that row into the DB, refreshes the table binding and show updated data.

It does update into the DB whenever I do however for some reason it does not refresh the binding sometimes! I have used table.refreshBinding(“props.data”), like it refreshed for one record then it doesn’t and like that…I also added one button with event to refresh table and same thing Continued. Upon reopening it shows updated record too.  
What could cause this?

I also have one column Boolean which has checkbox, sometimes it refreshes when I set checkbox to TRUE from FALSE or vice versa where ir updates into db not into table… !

---

<div class="post-metadata">

**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\
**Post date:** [May 25, 2022, 7:06pm UTC](https://forum.inductiveautomation.com/t/perspective-table-strange-behavior/60027/2 "2022-05-25T19:06:41Z")

</div>

Can you post the full code, using the \</\> button?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 25, 2022, 8:27pm UTC](https://forum.inductiveautomation.com/t/perspective-table-strange-behavior/60027/3 "2022-05-25T20:27:09Z")

</div>

It sounds as though the refresh binding is running before your table update has finished. Your code (using the `</>` button) might reveal something.

---

<div class="post-metadata">

**Author:** ![Gaurav.Shitole](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/gaurav.shitole/32/72050_2.png) [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\
**Post date:** [May 26, 2022, 8:47am UTC](https://forum.inductiveautomation.com/t/perspective-table-strange-behavior/60027/5 "2022-05-26T08:47:31Z")

</div>

Found the problem people!

It was refreshing Binding however as I had set Cache Query Result = True (under Named Query), it was not updating the data returned by query binding.

---

<div class="post-metadata">

**Author:** ![Adam\_Verellen](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/adam_verellen/32/33321_2.png) [@Adam\_Verellen](https://forum.inductiveautomation.com/u/Adam_Verellen)\
**Post date:** [June 21, 2022, 11:26am UTC](https://forum.inductiveautomation.com/t/perspective-table-strange-behavior/60027/6 "2022-06-21T11:26:15Z")

</div>

Fixed my problem too, thanks for posting