When using CustomExpressionBuilder add a property that make the expression/criteria columns read only
Arrrggh :) This doesn't quite work but I though I would post it anyway as it might provoke a thought
In conjunction with my other two requests about editing SQL output columns with QT and exposing a cell reference in CustomExpressionBuilder so you know exactly which cell the ellipsis was clicked on.
Both of these requests could be 'avoided' if when using the CustomExpressionBuilder the Expression, Criteria and Or cells were all made 'read-only'
By that I mean you can click the ellipsis to launch a custom dialog to do what you like in, even provide a free type text box if one wishes but when the text is returned to the cell, if it is read only, You then know when the user next clicks on the ellipsis the OldExpression value will be as you set it i.e. they can't change it, the custom dialog is in total control
It doesn't get around one really needs to store some metadata to save having to 'reverse engineer' the OldExpression string to populate the custom dialog ..... but at least you would be in control of what you were reverse engineering
Thanks for listening !
Thanks VERY much for this
Yes any time in the next couple of weeks would be brilliant
Whilst making them read-only gets around almost all of the challenges in that the user can't change the criteria outside of the custom dialog .....
Should the developer choose to offer a free type box then I believe they would need some way of knowing (via a flag they could set) that would tell them this was 'free typed' and therefore should just be placed back in that free type box in their dialog. Any code the developer has designed to "reverse engineer" the OldExpression value to populate their dialogs combo forms, check boxes etc could not be used due to the fact OldExpression could contain 'anything'