Page 1 of 4

Strange behavior of the Select field

Posted: Fri Apr 26, 2024 8:19 am
by 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?

Re: Strange behavior of the Select field

Posted: Fri Apr 26, 2024 8:45 am
by 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."

Re: Strange behavior of the Select field

Posted: Fri Apr 26, 2024 8:52 am
by kknm
Vag.png

Re: Strange behavior of the Select field

Posted: Fri Apr 26, 2024 8:58 am
by kev1n
So it is not an iFrame but a Subform?

Re: Strange behavior of the Select field

Posted: Fri Apr 26, 2024 9:02 am
by kknm
Yes.
This is before saving, after saving the first column, the second line takes the value of the first column.

Re: Strange behavior of the Select field

Posted: Fri Apr 26, 2024 9:26 am
by 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?

Re: Strange behavior of the Select field

Posted: Fri Apr 26, 2024 9:35 am
by 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.

Re: Strange behavior of the Select field

Posted: Fri Apr 26, 2024 10:18 am
by kknm
before.png
after.png

Re: Strange behavior of the Select field

Posted: Fri Apr 26, 2024 10:55 am
by 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?

Re: Strange behavior of the Select field

Posted: Fri Apr 26, 2024 11:07 am
by kknm
This form is independent of other forms on the main form. Only manual entry into this table.