Data Abstract Schema Modeler RemObjects Data Abstract Framework
Version 9.4.107.1363 Build date 2018-03-21
MSSQL 12
ADO
After updating to the latest build, Memo fields with an underlying text type field in mssql save with added spaces and other corruption. In the snip below you can see how text looks when entered on the lower item, and how it looks after saving and retrieval on the top item. This issue occurs on every project that I recompile since the installing the latest update.
I just sent a sent simple test case. Their is a button to open the table, a button to apply updates, a button to close the table, a dbNavigator and a dbMemo control all stock delphi.
To corrupt the text field, I open the table, edit the memo, Apply the updates, close the table, and reopen the table.
Was this a driver fix (i.e. MS SQL)? I’m seeing something similar using FireDAC and both Postgresql and mySQL. I’ll create some test cases if needed, but thought I’d ask first. I’m still using 9.2 which works fine, but would like to move to the later release.
What’s the easiest thing for you for the DB side of things that I can send as a sample? I’ve just tried the latest beta and it’s still got the problem (only building the server side shows this). It’s a field defined in the PostgreSQL DB as ‘text’, and in SM it’s a ‘memo’, and the problem is when saving from a client, the DB looks like it only gets the first letter of each word. As I say, I’ve seen it with mySQL too, so I guess I could create a test case with both.
I’m using Delphi XE8 (FireDAC is 22.0.19908). All is good with 9.2.103.1311