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

Error in AutoInsert

Are experiencing problems with something I suspect is the "uppercase as I type" feature. corrects it self when turned of

Every now and then it goes completely haywire.
Example:

have the following statement in an sql-file
UPDATE tblsak set SAStatus = @SAStatus WHERE SASaksNr=@SASaksNr

When I try to add spaces infront of and behind the = the following happends:

UPDATE tblsak set SAStatus = @SAStatus WHERE SASaELSE =@SASaksNr

and I have to do ctrl+z(undo) to correct the error
other variants of the same is replacement with VALUES and linebreak

Version info :
SQL Prompt v 2.0.0.59
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System Xp Prof sp2 ENG 5.1.2600
larso
0

Comments

1 comment

Sort by
  • Bart Read
    Hi larso,


    Thanks for reporting this, and sorry for the problems it's causing you. I think the problem here is down to the fairly simplistic parsing model in the current version of SQL Prompt. We'll be giving this a complete overhaul for version 3 which should be available sometime in September if all goes well.


    Many thanks,
    Bart Read
    0

Add comment

Please sign in to leave a comment.