Here's a little item editor

[Shendare]

Yeah. It'll skip over any input fields that it can't find a column for in the table based on its name (textEditCharmFile == items.charmfile, listEditItemType == items.itemtype, etc.), and any leftover columns that it doesn't find input fields for it dumps as textboxes in the Unrecognized tab.

It also dynamically recognizes the type of each column (int, float, date, varchar) and formats inputs appropriately to avoid errors as much as possible.

Should work pretty well no matter what.