I have a query:
select id r,
name d
from DEVICES_TYPE
order by 2;
The return values selected are correct, but after page reopened the display value in th field doesn't fit
the return value. It happens in particular cases. In my case the are two rows in database:
1) name: scales; id: 2
2) name: RFID-reader; id: 24
So when I choose 'scales' it writes in th db right id (2), and when the form is reopened the id in the session
is correct. But the field displays 'RFID-reader'.
if the ORDER clause is removed and the query is:
select id r,
name d
from DEVICES_TYPE
everything works fine. But without order in the list (
SlavaAtamanskiy
commented
5 years ago
I have a query: select id r, name d from DEVICES_TYPE order by 2;
The return values selected are correct, but after page reopened the display value in th field doesn't fit the return value. It happens in particular cases. In my case the are two rows in database: 1) name: scales; id: 2 2) name: RFID-reader; id: 24 So when I choose 'scales' it writes in th db right id (2), and when the form is reopened the id in the session is correct. But the field displays 'RFID-reader'.
if the ORDER clause is removed and the query is:
select id r, name d from DEVICES_TYPE
everything works fine. But without order in the list (