# Edit dataset, then copy to SQL?

**URL:** <https://forum.inductiveautomation.com/t/edit-dataset-then-copy-to-sql/26494>\
**Category:** Ignition\
**Created:** [July 11, 2019, 9:11pm UTC](https://forum.inductiveautomation.com/t/edit-dataset-then-copy-to-sql/26494 "2019-07-11T21:11:44Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [July 12, 2019, 11:58am UTC](https://forum.inductiveautomation.com/t/edit-dataset-then-copy-to-sql/26494/5 "2019-07-12T11:58:03Z")

</div>

If you're going the two-dataset route, this thread my help you out.

> [@Comparing Two Datasets Values, and using those to determine difference](http://forum.inductiveautomation.com/t/comparing-two-datasets-values-and-using-those-to-determine-difference/23676):
>
> Hi, I need to compare two datasets in a power table. in this table the user inputs parts and qty for an order. what i want to do it is the following. This Dataset are for the Power Table SelDS=Query from DB were ordernumber=value (polling Off) EmptyDS= a five column empty dataset Table.data = (Power Table dataset) if the order is being edited(Meaning the table already has values in it SelDS saved. Table in Ignition (SelDS) [image] let’s say i change the value of the Case to Ship column …

IMO, it would be less hassle to make the table editable, and write back to the db using onCellEdited (assuming Power Table).

---

_[View the full topic](https://forum.inductiveautomation.com/t/edit-dataset-then-copy-to-sql/26494)._