Can't show VIEW in Sql Server 2008 R2
| User, date | Message |
|---|---|
|
Written by matsg
3 months ago Category: General 8 posts since Tue, 24 Jan 12 |
Hi, I can't display views or stored procedured on SQL Server 2008 R2 with HeidiSQL - I just get an exception. It seems like there's a problem with some kind of parsing routine. Not sure if this forum is where you place bug reports? date/time : 2013-03-12, 08:42:33, 508ms computer name : MIKE-THINKPAD user name : Mike <admin> registered owner : Mike operating system : Windows 7 x64 Service Pack 1 build 7601 system language : English system up time : 1 day 13 hours program up time : 2 minutes 13 seconds processors : 4x Intel(R) Core(TM) i5-2410M CPU @ 2.30GHz physical memory : 978/3983 MB (free/total) free disk space : (C:) 200.16 GB display mode : 1920x1080, 32 bit process id : $15e8 allocated memory : 60.50 MB executable : heidisql.exe exec. date/time : 2013-03-12 08:40 version : 7.0.0.4362 compiled with : Delphi XE madExcept version : 3.0m beta 1 callstack crc : $bbc5382c, $4ea5a3bc, $4ea5a3bc exception number : 1 exception class : Exception exception message : Regular expression did not match the VIEW code in ParseViewStructure(): CREATE VIEW [dbo].[vewCostCentreRights] AS SELECT DISTINCT uc.UserId, C.CostId, C.Description FROM tblCost C JOIN UserClaim uc ON uc.Claim = C.BusinessId WHERE uc.CategoryId = 100 UNION SELECT DISTINCT uc.UserId, C.CostId, C.Description FROM tblCost C JOIN tblCostCentreTree Ct ON C.CostId = Ct.CostCentreId, tblCostCentreTree AS Ct2 JOIN tblCost C2 ON Ct2.CostCentreId = C2.CostId JOIN UserClaim uc ON uc.Claim = C2.BusinessId WHERE Ct.lft BETWEEN Ct2.lft AND Ct2.rgt AND Ct.TreeId = Ct2.TreeId AND uc.CategoryId = 100 UNION SELECT DISTINCT ur.UserId, C.CostId, C.Description FROM tblCost C JOIN RoleClaim rc ON rc.Claim = C.BusinessId JOIN UserRole ur ON rc.RoleId = ur.RoleId WHERE rc.CategoryId = 100 Union SELECT DISTINCT ur.UserId, C.CostId, C.Description FROM tblCost C JOIN tblCostCentreTree Ct ON C.CostId = Ct.CostCentreId, tblCostCentreTree AS Ct2 JOIN tblCost C2 ON Ct2.CostCentreId = C2.CostId JOIN RoleClaim rc ON rc.Claim = C2.BusinessId JOIN UserRole ur ON rc.RoleId = ur.RoleId WHERE Ct.lft BETWEEN Ct2.lft AND Ct2.rgt AND Ct.TreeId = Ct2.TreeId AND rc.CategoryId = 100 UNION SELECT DISTINCT U.UserId, C.CostId, C.Description FROM tblCost C JOIN Users U ON C.OrgId = U.OrgId JOIN UserClaim UC ON UC.UserId = U.UserId WHERE UC.Claim = '7A9F94CD-38CC-4DD4-A79C-4D3360EBC23D' UNION SELECT DISTINCT U.UserId, C.CostId, C.Description FROM tblCost C JOIN Users U ON C.OrgId = U.OrgId JOIN UserRole UR ON U.UserId = UR.UserId JOIN RoleClaim RC ON RC.RoleId = UR.RoleId WHERE RC.Claim = '7A9F94CD-38CC-4DD4-A79C-4D3360EBC23D'. main thread ($de0): 0072c59c heidisql.exe dbconnection 3435 +30 TDBConnection.ParseViewStructure 007fb03e heidisql.exe Main 7184 +60 TMainForm.DBtreeFocusChanged 00622aae heidisql.exe VirtualTrees TBaseVirtualTree.DoFocusChange 00626e4a heidisql.exe VirtualTrees TBaseVirtualTree.HandleMouseDown 004e97f4 heidisql.exe Controls TControl.DoMouseDown 0061ee4c heidisql.exe VirtualTrees TBaseVirtualTree.WMLButtonDown 0062b4ef heidisql.exe VirtualTrees TBaseVirtualTree.WndProc 004ed100 heidisql.exe Controls TWinControl.MainWndProc 004ab958 heidisql.exe Classes StdWndProc 75437885 USER32.dll DispatchMessageW 00575ffb heidisql.exe Forms TApplication.ProcessMessage 0057603e heidisql.exe Forms TApplication.HandleMessage 00576369 heidisql.exe Forms TApplication.Run 00817bf0 heidisql.exe heidisql 75 +23 initialization 753233a8 kernel32.dll BaseThreadInitThunk Thanks, Matt |
|
Written by ansgar
3 months ago 4024 posts since Fri, 07 Apr 06 |
Please read issue #2496, be sure to have the latest HeidiSQL build, and report the above error with a comment there if it does not disappear after the update. |
|
Please login to leave a reply, or register at first. |