Hi,

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.

Thanks,

Craig.

asked 05 May '13, 14:15

Craig's gravatar image

Craig
1.1k246
accept rate: 6%

I second the request to have a larger edit area for the where clause.

Michiel

(05 May '13, 15:08) Michiel A

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.

Best Regards,
Ibrahim

link

answered 06 May '13, 07:38

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Great, thanks.

(06 May '13, 10:25) Craig
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×67
×5
×3

Asked: 05 May '13, 14:15

Seen: 1,017 times

Last updated: 06 May '13, 10:25


© Copyright Gerger 2017