Edit dataset, then copy to SQL?

[JordanCClark]

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

Comparing Two Datasets Values, and using those to determine difference

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