How can we help you today? How can we help you today?

DEFECT REPORT: Sql Prompt Alias for OPENQUERY in wrong place

The text entered when hitting tab upon typing 'OPENQ' (to expand the OPENQUERY suggestion) yields the following:
SELECT
	*
FROM
	OPENQUERY AS O

The cursor follows the O alias. It should do the following:
SELECT
	*
FROM
	OPENQUERY() AS O

The cursor should be between the parenthesis.
njahncke
0

Comments

2 comments

Sort by
  • Mike U
    There's a SQL Prompt option to enable this behaviour.

    From the SQL Prompt 5 menu, select 'Options...', then select 'Inserted code -> Special characters' in the tree, and enable the "Add parentheses () when inserting a function or data type" option.
    Mike U
    0
  • njahncke
    Great! That did the trick. Thanks!
    njahncke
    0

Add comment

Please sign in to leave a comment.