A simple suggestion to improve the Datasource Query editor, it would be useful if you could double-click or press a button on the WHERE Clause textArea and it opens an editor dialog that could be resized to any size, working on complex WHERE clauses in the few lines currently visible makes it quite tricky such that I've been resorting to entering the WHERE in another tool and copying and pasting into FS.
Same would also be useful on SELECT and ORDER BY fields as well.
Furthermore, it would be useful if there was a button you could press that would show you the fully constructed SQL statement that FS will issue at runtime; it would just help the developer to be able to see the full SQL.
Another idea that I think would be useful was if you right-click the WHERE clause, it would list the available bind variables, selecting one would insert the variable at the current cursor; just a simple time saver that would help when working with complex queries with many bind vars.
asked 05 May '13, 14:15
Hi Craig and Michiel,
Thanks for your feedback. I accept that it would be useful to open an editor dialog for these fields. I registered a ticket in our issue management system regarding your suggestions, we will evaluate them for the future releases.
answered 06 May '13, 07:38
Ibrahim Sand... ♦♦