Page 1 of 1

Failed to apply updates to NTEXT fields

Posted: Wed 08 Apr 2009 16:49
by Dmitri
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.

Posted: Thu 09 Apr 2009 14:13
by Dimon
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next SDAC build.