SqlDbx Forum

SqlDbx

You are not logged in.

#1 2009-07-24 11:02:17

allanb
Guest

Speed typing and Intellisense bug

I created speed type shortcut as follows
Shortcut: newproc
Substitution Value:

IF OBJECT_ID('dbo.xxx') IS NOT NULL
     DROP PROC dbo.xxx
GO

CREATE PROC dbo.xxx
AS
--    DESCRIPTION:
--    PARAMETERS:
--    SAMPLE: EXEC xxx
BEGIN
END

Now when I type newproc in Editor Intellisense box pops up but it is very wide and can go outside the screen.

#2 2009-07-27 11:33:25

sqldbxhelp
Administrator

Re: Speed typing and Intellisense bug

This is unexpected use for Speed Typing.
You could use SQL templates for something like this.
You are right about wide popup and it will be fixed in a next release.
Here's couple of improvements you can use.
Instead of newproc in Shortcut column type : newproc (name)
and in Substitution Value column type:

IF OBJECT_ID('dbo.$(name)') IS NOT NULL
     DROP PROC dbo.$(name)
GO

CREATE PROC dbo.$(name)
AS
--    DESCRIPTION:
--    PARAMETERS:
--    SAMPLE: EXEC $(name)
BEGIN
END

Save  and exit Speed Typing dialog.
Now in editor type newproc(sp_newproc) and see how it will be expanded.

Offline

#3 2009-07-28 16:29:14

allanb
Guest

Re: Speed typing and Intellisense bug

Nice. Thank you

Board footer

Powered by FluxBB