Re: Drop down choice is not being maintained
Posted: Mon Nov 25, 2013 11:43 am
What version of Profound UI are you using? And do you know what security mode you are using?
See here:
http://www.profoundlogic.com/docs/displ ... urity+Mode
If you are using 4.5.0 or higher, the 'Enhanced' mode is the default, and it would have to be turned off using the configuration environment variable mentioned there. If you are not using this Enhanced mode, then that session database is not used. In that case, you wouldn't be able to see the SQL statements.
But, you could build the SQL statement that it uses manually like this:
That is how it builds the statement -- just paste in the approp. property values where indicated. Then check to see if your bound 'value' matches exactly to the 'choice values field' expression. Something must be slightly different about it.
See here:
http://www.profoundlogic.com/docs/displ ... urity+Mode
If you are using 4.5.0 or higher, the 'Enhanced' mode is the default, and it would have to be turned off using the configuration environment variable mentioned there. If you are not using this Enhanced mode, then that session database is not used. In that case, you wouldn't be able to see the SQL statements.
But, you could build the SQL statement that it uses manually like this:
Code: Select all
SELECT DISTINCT
[CHOICE OPTIONS FIELD], [CHOICE VALUES FIELD]
FROM
[CHOICES DATABASE FILE]
WHERE
[CHOICES SELECTION CRITERIA]
ORDER BY
[ORDER BY]