Failed to apply updates to NTEXT fields

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Dmitri
Posts: 9
Joined: Wed 19 Jan 2005 22:58

Failed to apply updates to NTEXT fields

Post by Dmitri » Wed 08 Apr 2009 16:49

Hi,

Moving from older C++ Builder 6 to newest RAD 2009 C++ Builder to make Unicode support enabled for our clients.

SDAC components are on RDM in our DataSnap apps server,
to which we connect from client side by using:

TDataSource->TClientDataSet->...DataSnap connectivity...->RDM->TDataSetProvider->TMSQuery->TMSUpdateSQL->TMSConnection->SQL Server DB.

Found, that everything working well, except we cannot update NTEXT fields with Unicode string in SQL Server DB, only AnsiString compliant...

However, when shorted up the chain of components, to eliminate TDataSetProvider:
TDataSource->TMSQuery->TMSUpdateSQL->TMSConnection->SQL Server DB
- it works well.

Full chain works well with standard CodeGear dbExpress components
istead of TMSQuery and TMSConnection

However, we do like to move away from SDAC ...

Created and send to your support email address test project, which demonstrates this problem even in single application.

Please investigate the problem and let us know, it is a full conversion stopper for us.

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 09 Apr 2009 14:13

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next SDAC build.

Post Reply