Forum Discussion

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

SQL Table Editor Unable to Save Data

OS Version 7.4.2 I have a SQL Table Editor in a dashboard.  Three columns: Date, Amount, Descr.  The user can edit Amount and Descr. No Inserts, no deletes. The table loads with a bunch of dates.  ...
Extensibility
  • ckattookaran's avatar
    ckattookaran
    2 years ago

    That is interesting. It should do what you are doing as a SQL already unless somehow the keys are messed up, and SQLTableEditor is sending queries to update multiple records.

  • RobbSalzmann's avatar
    RobbSalzmann
    2 years ago

    Yep, I added a PK column and the STE cooperates.  Professionally I have some thoughts about this, but I'll leave it as solved and kudo you the solution for giving me the idea and the time you spent sharing your thoughts!  Cheers.



RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II

The following code is working.  It uses the STE as a dirty-cell aware spreadsheet, then writes and executes its own queries.  The requirement is straightforward: update rows in a table with values the user enters. 

IMO, a component called "SQL Table Editor" should be able to do this unassisted by code when its Save button is clicked.  I would like to be wrong here and learn what I'm missing.  At this point it feels like a bug.

 

 

 

 

ckattookaran's avatar
ckattookaran
VIP
2 years ago

That is interesting. It should do what you are doing as a SQL already unless somehow the keys are messed up, and SQLTableEditor is sending queries to update multiple records.

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    Yep, I added a PK column and the STE cooperates.  Professionally I have some thoughts about this, but I'll leave it as solved and kudo you the solution for giving me the idea and the time you spent sharing your thoughts!  Cheers.