Entity Fields - SQL List - Allow <%FieldName%> As Valid SQL

The Data Combo box allows you to write a SQL Statement to product a list of value, within that SQL you use <%FieldName%> if you need to filter by a value on the record.

Can the Entity Field validation PLEASE be updated so that when I create a field that does a SQL Statement for it's values (so that the generated forms show a data combo box) that it knows <%FieldName%> is valid SQL in this instance.

It's SUPER annoying to see the "The BlahBlah field does not have a valid SQL statement defined within the first Entity Field Value record's value field.... blah blah....". As well it means I don't actually know I have invalid SQL till I open the Form and see the box with the red x in it.

0

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post