SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SET IDENTITY_INSERT is getting quoted identifiers on command

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SET IDENTITY_INSERT is getting quoted identifiers on command
Author Message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post SET IDENTITY_INSERT is getting quoted identifiers on command Reply with quote
v3.0.28

Type the following
SET I<ENTER>

you will get

SET [IDENTITY_INSERT]

which is not valid. "Always Add Delimeters" is set to none.
Tue Dec 11, 2007 12:12 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
This is a bug. SQL Assistant attempts to wrap in brackets all keywords used for object/column names. SET is not an applicable case for that.

To fix it on your end, you can remove SET commands from the Intellisense options - remove them from the Custom Assistance edit box in the "SQL Assistant" option group; or create a snippet to have the entire line inserted automatically, for example, name it sii and then use sii<CTRL><ENTER> to insert the text into the code.
Tue Dec 11, 2007 2:21 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.