DEFECT REPORT: Sql Prompt Alias for OPENQUERY in wrong place

njahncke

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.

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.

njahncke

Great! That did the trick. Thanks!