Schema Manager: Field type ftDbaseOle (20) is not supported

Data Abstract
,
1

Hi guys,

Delphi Berlin Update 2, latest DataAbstract Server version.

Using the Schema Editor via FireDAC connection, I get a small red x next to a table and if i hover the mouse over I can see this error

“error on data type Field type ftDbaseOle (20) is not supported”

And one of the fields doesnt show up on the list of fields of the table. The field missing is defined on the db (MSSQL 2008) as

[GameXML] [xml] NOT NULL,

Using ADO I can see the table. Using FireDac directly it also seems to work, any ideas?

2

can you post DDL for this table, pls?
you can attach it here or post directly to support@

3

Hi Evgeny,

Data Abstract Schema Modeler
RemObjects Data Abstract Framework
Version 9.1.99.1273
Build date 2016-11-01
Copyright RemObjects Software, LLC 2002-2016. All Rights Reserved.

Currently testing on Delphi 10 Seattle.

Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Apr 29 2016 23:23:58 Copyright © Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600: ) (Hypervisor)

Test table:

CREATE TABLE [dbo].[ATestTable](
[Id] [int] IDENTITY(1,1) NOT NULL,
[AXML] [xml] NOT NULL,
[ADate] datetime2 NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

Interesting enough, using ADO i’m getting no error message, but the XML field is not being displayed at all among the table fields on the Schema Modeler.

Thank you in advance.

4

xml type is detected by FireDAC as ftDBaseOle field.
ADO just ignores this field.

as a workaround, you can add ftDBaseOle into VCLTypeToDAType method (uDACore.pas) and map it as datBlob

after this, you need to recompile ..\Drivers\DAFireDACDrv.dpr and put generated .dad near to DASM

5

Thanks, logged as bugs://77330

6

bugs://77330 got closed with status fixed.

7

Logged as bugs://i65056.

8

bugs://i65056 was closed as fixed.