TMSTable.Tablename := '[Database]'
Posted: Thu 04 Jul 2013 08:37
Hi,
we've got a database that contains a table named '[dbo].[Database]'. I can query the table just fine, but the TMSTable component is unable to open this table.
SQL Server complains about incorrect syntax.
We're using SDAC 6.6.12
This is the table CREATE statement:
Edit:
In addition the TMSQuery component is able to open the table with 'SELECT * FROM [dbo].[Database]', but calling `Append` causes the same error message.
we've got a database that contains a table named '[dbo].[Database]'. I can query the table just fine, but the TMSTable component is unable to open this table.
SQL Server complains about incorrect syntax.
We're using SDAC 6.6.12
This is the table CREATE statement:
Code: Select all
CREATE TABLE [dbo].[Database] (
[Database_ID] UNIQUEIDENTIFIER CONSTRAINT [DEF_Database_Database_ID] DEFAULT newid() NOT NULL,
[Name] NVARCHAR(40) COLLATE Latin1_General_CI_AS NOT NULL,
[Info] NVARCHAR(max) COLLATE Latin1_General_CI_AS,
[ArchiveMode] INTEGER CONSTRAINT [DEF_Database_ArchiveMode] DEFAULT 0 NOT NULL,
CONSTRAINT [PK_Database] PRIMARY KEY NONCLUSTERED ([Database_ID])
)
GO
CREATE UNIQUE CLUSTERED INDEX [IDX_Database_1] ON [dbo].[Database] ([Name] ASC)
GOIn addition the TMSQuery component is able to open the table with 'SELECT * FROM [dbo].[Database]', but calling `Append` causes the same error message.