Snippet for INSERT INTO CursorHere WITH TABLOCK

• 
  I'll see what I can do about keeping the table hints with the table name

  Aaron L January 24, 2014 04:43

  - 0 +
• 
  Thanks Aaron!

  kondrich January 24, 2014 04:46

  - 0 +
• 
  Hi Klaus,
  I've just updated our beta to 6.3.0.65 which should include this and a fix for the semicolon bug you reported. You can download it from the same URL as before.

  Aaron L January 27, 2014 09:20

  - 0 +
• 
  Aaron,
  
  thanks for the new version. It's partially working: It seems that we have a semicolon issue here again.
  If the ii snippet is defined as

  INSERT INTO $CURSOR$ WITH (TABLOCK)
  

  it gets correctly expanded to

  INSERT INTO TableName WITH (TABLOCK)
  		(ColumnName)
  VALUES	(0  -- ColumnName- smallint
  		 )
  

  However, if the snippet is defined as

  INSERT INTO $CURSOR$ WITH (TABLOCK);
  

  (note the trailing semicolon) and I start typing ii+TAB: this leads to

  INSERT INTO | WITH (TABLOCK);
  

  (The pipe indicates the cursor position) So everything is fine until now. But after choosing a table name, the generated code gets replaced by:

  INSERT INTO TableName
  		(ColumnName)
  VALUES	(0  -- ColumnName- smallint
  		 )
  

  ...the table hint and the trailing semicolon are missing after full generation of the code.

  kondrich January 27, 2014 09:34

  - 0 +
• 
  Ok, one more try with 6.3.0.70 This build should keep the tablehint with the name and place the semicolon after the autogenerated code.

  Aaron L January 28, 2014 08:29

  - 0 +
• 
  OK, 6.3.0.70 fixes that one. Thank you!

  kondrich January 29, 2014 03:27

  - 0 +

Add comment

Please sign in to leave a comment.