Hi there,
I’m using Delphi Seattle with the latest release (non beta) of DA Server. I have a table with the following structure:
CREATE TABLE [importer].[BettingEventQueue](
[QueueItemId] [int] IDENTITY(1,1) NOT NULL,
[ProviderItemId] [int] NULL,
[ProviderId] [smallint] NOT NULL,
[GameXML] [xml] NOT NULL,
[StatusId] [smallint] NOT NULL CONSTRAINT [DF_importer_BettingEventQueue__StatusId] DEFAULT ((0)),
[AttemptCount] [smallint] NOT NULL CONSTRAINT [DF_importer_BettingEventQueue__AttemptCount] DEFAULT ((0)),
[LastAttempt] [datetime] NULL,
[QueueEventTypeId] [smallint] NOT NULL,
[QueueTypeId] [smallint] NOT NULL CONSTRAINT [DF_importer_BettingEventQueue__QueueTypeId] DEFAULT ((0)),
[ParentQueueItemId] [int] NULL,
[Created] [datetime] NOT NULL CONSTRAINT [DF_importer_BettingEventQueue__Created] DEFAULT (getutcdate()),
[CreatedBy] [int] NULL,
[Updated] [datetime] NULL,
[UpdatedBy] [int] NULL,
CONSTRAINT [PK_BettingEventQueue] PRIMARY KEY CLUSTERED
(
[QueueItemId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
On a MSSQL 2014 server. If I try to add this table to a schema via the Schema Modeler I get an error message
"Unable to obtain metadata for FD_TradingDB. Please, specify target" If I use FireDac and if I use ADO it will simply not include the GameXML field as part of the fields of the table.
Using FireDac directly will recognize the XML field. It seems to be a Data Abstract Schema Modeler issue, any help on how to make this work?
Thank you.
