Error when trying to show a view on MS SQL
| User, date | Message |
|---|---|
|
Written by oz8hp
6 months ago Category: HeidiSQL portable 6 posts since Mon, 08 Oct 12 |
When I connect to MS SQL and try to open a view I get this error. It happens no matter what view and what database. The view are OK when using DatAdmin or management studio so I guess the error is in HeidiSQL date/time : 2012-12-20, 09:17:12, 573ms computer name : HP-T5400 user name : HP <admin> registered owner : HP operating system : Windows 7 x64 Service Pack 1 build 7601 system language : Danish system up time : 2 hours 49 minutes program up time : 2 minutes 32 seconds processors : 4x Intel(R) Xeon(R) CPU E5410 @ 2.33GHz physical memory : 960/4094 MB (free/total) free disk space : (C:) 175,76 GB display mode : 1920x1200, 32 bit process id : $1494 allocated memory : 69,00 MB executable : heidisql.exe exec. date/time : 2012-12-20 09:14 version : 7.0.0.4285 compiled with : Delphi XE madExcept version : 3.0m beta 1 callstack crc : $bbc5382c, $502b8ca4, $502b8ca4 exception number : 6 exception class : Exception exception message : Regular expression did not match the VIEW code in ParseViewStructure(): CREATE TABLE "qryjs_companies" ( "fldcompany_guid" VARCHAR(50) NOT NULL, "fldcompany_number" VARCHAR(50) NULL, "fldcompany_name" VARCHAR(100) NULL, "fldcompany_section_guid" VARCHAR(50) NULL, "fldcompany_att" VARCHAR(100) NULL, "fldcompany_address1" VARCHAR(100) NULL, "fldcompany_address2" VARCHAR(100) NULL, "fldcompany_zip" VARCHAR(10) NULL, "fldcompany_phone" VARCHAR(15) NULL, "fldcompany_mobile" VARCHAR(15) NULL, "fldcompany_mail" VARCHAR(250) NULL, "fldcompany_web" VARCHAR(250) NULL, "fldcompany_notes" TEXT(2147483647) NULL, "flddatelast" DATETIME NULL, "flddatenext" DATETIME NULL, "flddatediff" INT NULL, "fldhide" BIT NULL, "flddocname" VARCHAR(100) NULL, "fldcreated_computer" VARCHAR(50) NULL, "fldcreated_by" VARCHAR(50) NULL, "fldcreated_date" DATETIME NULL, "fldupdated_computer" VARCHAR(50) NULL, "fldupdated_by" VARCHAR(50) NULL, "fldupdated_date" DATETIME NULL, "fldsection_desc" VARCHAR(50) NULL, "fldcity" VARCHAR(50) NULL). main thread ($10d4): 00729998 heidisql.exe dbconnection 3377 +30 TDBConnection.ParseViewStructure 007f6a96 heidisql.exe Main 7174 +59 TMainForm.DBtreeFocusChanged 0062151a heidisql.exe VirtualTrees TBaseVirtualTree.DoFocusChange 00625940 heidisql.exe VirtualTrees TBaseVirtualTree.HandleMouseDown 004e9728 heidisql.exe Controls TControl.DoMouseDown 0061d8b8 heidisql.exe VirtualTrees TBaseVirtualTree.WMLButtonDown 00629bcb heidisql.exe VirtualTrees TBaseVirtualTree.WndProc 004ed034 heidisql.exe Controls TWinControl.MainWndProc 004ab88c heidisql.exe Classes StdWndProc 76a47885 USER32.dll DispatchMessageW 00575f0f heidisql.exe Forms TApplication.ProcessMessage 00575f52 heidisql.exe Forms TApplication.HandleMessage 0057627d heidisql.exe Forms TApplication.Run 00813bf0 heidisql.exe heidisql 75 +23 initialization 766633a8 kernel32.dll BaseThreadInitThunk |
|
Written by ansgar
6 months ago 4025 posts since Fri, 07 Apr 06 |
This is a known issue in MSSQL mode, see issue #2496. Unfortunately, there is very few feedback from MSSQL users, so related errors are mostly not even seen or reported. But I think I should at least fix the known issues for the next release, so MSSQL users can more rely on HeidiSQL. |
|
Written by oz8hp
6 months ago 6 posts since Mon, 08 Oct 12 |
OK - I will wait and see I mostly use HeidiSQL for MySQL anyway |
|
Please login to leave a reply, or register at first. |