Page 1 of 1

Support Xml in MSSQL

Posted: Tue 22 Jan 2019 15:12
by Vlastelin
I use TFireDACDataProvider.

Code: Select all

var Doc := FMyContext.Document;
var Query := Linq.From(Doc).Select([Doc.XmlOriginal]).Take(1); // XmlOriginal Field in MSSQL is XML
EntityDataSet1.SourceCollection := FStingray.GetEntities(Query);
EntityDataSet1.Open; // this error EProviderException with message '[TFieldProvider] Unsupported data type for the XmlOriginal field: ftDBaseOle'
I tried

Code: Select all

[Column('XmlOriginal')]
FXmlOriginal: TXMLData;
and

Code: Select all

[Column('XmlOriginal')]
FXmlOriginal: string;

Re: Support Xml in MSSQL

Posted: Wed 23 Jan 2019 16:44
by MaximG
Thank you for the information. We will investigate the described issue and let you know the results shortly.

Re: Support Xml in MSSQL

Posted: Tue 05 Feb 2019 09:24
by Vlastelin
Any results?

Re: Support Xml in MSSQL

Posted: Tue 05 Feb 2019 12:12
by MaximG
We have started the implementation and look forward to receiving results quickly, of which we will immediately notify you