ERROR - Using views made by MS SQL Server Management studio

2 posts
[expired user #9955]'s profile image [expired user #9955] posted 8 years ago in General Permalink

hSQL is not able to open my views created by MS SQL Server Management studio.

  • exception message : Regular expression did not match the VIEW code in ParseViewStructure(): CREATE VIEW[dbo].[Dev-2 NL$ECON$BrandLineRefPrices2] AS SELECT * FROM [dbo].[Dev-2 NL$ECON$BrandLineRef] as BLref.

Problem is that there is no space between VIEW and [dbo]. But MS accepts it (and probably generates it ) without space

Please login to leave a reply, or register at first.