Using Display and Value of <select>

WEB TMS WEB Core
1

When editing, I want the Status Display to show the full text, but only save the character for it. If I enter Key-Value pairs in the Items of the TWebDBComboBox, the html generated is correct

<select id="view.staff.form.edStatus" class="form-control" role="combobox" style="">
<option value="A">Active</option>
<option value="D">Deleted</option>
<option value="I">Inactive</option>
</select>

However, if the user selects say Inactive, nothing gets saved to the database.

Is there a way to leverage this?

To track whats happening above, how can I log the actual sql statements being executed by the REST server?

2

What kind of dataset is connected and how is this dataset supposed to update the database?

To begin with, did you check the field value in the dataset connected to this TWebDBCombobox?

3

The field value was 'Active' instead of the expected 'A". So, I am fixing it before doing Dataset.Post. From the user's point of view, it is now working as expected.

I would have preferred to intercept it at the REST server and fix it there.