Strange behavior of the Select field

[kknm]

On the main form there is a form (IFRAME), in which there is a table with only 2 rows and 10 fields. To select the beginning of the line, use the (Select) field.
At first I used json/array of type ['One','Two'] , but after a few days I noticed that fields were selected from the list, but were not saved in the database... When I clicked the Save button, the field with Select was cleared.in the database this field was of type varchar(25)
Then I switched to a new method of selecting from Select like 0|One|1|Two but... another problem appeared - the fields are selected correctly, but when saving, the field (Two) is replaced by One and naturally only 0 is saved in the database.in the database this field was of tinyint type
How to deal with this?

[kev1n]

Hi,

Are you experiencing this problem only in that (iframe) form, or in any form where select objects are used?
Also post a screenshot to illustrate "On the main form there is a form (IFRAME), in which there is a table with only 2 rows and 10 fields. To select the beginning of the line, use the (Select) field."

[kknm]

Vag.png

[kev1n]

So it is not an iFrame but a Subform?

[kknm]

Yes.
This is before saving, after saving the first column, the second line takes the value of the first column.

[kknm]

By the way, this is not the only oddity of this subordinate form. Columns 1-15 are prefixed with 'v', i.e. v1,v2,v3...
When you enter numeric values ​​in these columns, when saved, they are not saved in all columns - only in 5-15.
Maybe this is due to some limitation on the number of columns?

[kev1n]

Can you take a screenshot of what it looks like before and after saving? Just enter some values before saving so I get a better picture of what is happening.

[kknm]

before.png

after.png

[kev1n]

Only the first object is a select? The other objects are input objects? So the problem is not the select, but the other fields?

[kknm]

This form is independent of other forms on the main form. Only manual entry into this table.