Error when trying to show a view on MS SQL

User, date Message
Written by oz8hp
1 year 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 :
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
1 year ago
4783 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
1 year 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.