# Data Abstract **URL:** https://talk.remobjects.com/c/da/3.md [Latest](https://talk.remobjects.com/latest.md) · [Categories](https://talk.remobjects.com/categories.md) · [Tags](https://talk.remobjects.com/tags.md) --- ## [How do you clear deltas in C# .NET DataAbstract adapter](https://talk.remobjects.com/t/how-do-you-clear-deltas-in-c-net-dataabstract-adapter/34183)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 5\ **Last updated:** [October 21, 2026, 8:15am UTC](https://talk.remobjects.com/t/how-do-you-clear-deltas-in-c-net-dataabstract-adapter/34183 "2026-10-21T08:15:45Z")
I have a dataadapter on which I prepare row operations Type is LinqDataAdapter At some point I ask if the user wants to proceed and then perform dataAdapterTags\_.CancelChanges(); when the user answers ‘no’ When I re… --- ## [.NET Data Abstract Appserver Integrating Bedrock](https://talk.remobjects.com/t/net-data-abstract-appserver-integrating-bedrock/34107)
**Author:** [@Chronicle](https://talk.remobjects.com/u/Chronicle)\ **Replies:** 4\ **Last updated:** [October 15, 2026, 1:46pm UTC](https://talk.remobjects.com/t/net-data-abstract-appserver-integrating-bedrock/34107 "2026-10-15T13:46:31Z")
Hey guys! It’s been a while. I’m about to refactor the DA app server, and one of the things I’d like to explore is adding Amazon Bedrock. My first thought is to build a Bedrock service directly into the DA app server. … --- ## [Default value for datatabele fields](https://talk.remobjects.com/t/default-value-for-datatabele-fields/34137)
**Author:** [@tstoicescu](https://talk.remobjects.com/u/tstoicescu)\ **Replies:** 3\ **Last updated:** [October 14, 2026, 12:59pm UTC](https://talk.remobjects.com/t/default-value-for-datatabele-fields/34137 "2026-10-14T12:59:00Z")
Hello, When mapping a table using SchemaModeler, default field values ​​are captured as well, which is great. However, FirebirdSQL TIMESTAMP fields support constants such as CURRENT\_TIMESTAMP, CURRENT\_DATE, ‘NOW’, etc. … --- ## [TDAVCLReconcileProvider not in Delphi 13 64 bit?](https://talk.remobjects.com/t/tdavclreconcileprovider-not-in-delphi-13-64-bit/32519)
**Author:** [@kbripleyindcom](https://talk.remobjects.com/u/kbripleyindcom)\ **Replies:** 3\ **Last updated:** [October 12, 2026, 3:04pm UTC](https://talk.remobjects.com/t/tdavclreconcileprovider-not-in-delphi-13-64-bit/32519 "2026-10-12T15:04:44Z")
--- ## [Add a sql server table-valued function in schema](https://talk.remobjects.com/t/add-a-sql-server-table-valued-function-in-schema/28912)
**Author:** [@infolyseis](https://talk.remobjects.com/u/infolyseis)\ **Replies:** 14\ **Last updated:** [September 4, 2026, 1:44pm UTC](https://talk.remobjects.com/t/add-a-sql-server-table-valued-function-in-schema/28912 "2026-09-04T13:44:18Z")
Hi, is there a way to add to the schema a function that has two parameters and returns a dataset based on these parameters? If not is there another way to have that kind of functionality? Thanks in advance Yiannis --- ## [Is there a known memory/thread/handle leak in RO v10.0.0.1611](https://talk.remobjects.com/t/is-there-a-known-memory-thread-handle-leak-in-ro-v10-0-0-1611/33900)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 9\ **Last updated:** [September 2, 2026, 11:39am UTC](https://talk.remobjects.com/t/is-there-a-known-memory-thread-handle-leak-in-ro-v10-0-0-1611/33900 "2026-09-02T11:39:30Z")
On production systems we see resource leaks in one of our .NET RO servers While running for days we see thread & handle count going up We also see memory (private bytes & WS) going up. When analysing with process expl… --- ## [Why does the number of instances of a pooled service drop below the initial pool size](https://talk.remobjects.com/t/why-does-the-number-of-instances-of-a-pooled-service-drop-below-the-initial-pool-size/33895)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 3\ **Last updated:** [September 2, 2026, 8:46am UTC](https://talk.remobjects.com/t/why-does-the-number-of-instances-of-a-pooled-service-drop-below-the-initial-pool-size/33895 "2026-09-02T08:46:36Z")
I am creating a pooled service with an initial pool size of 10 and an infite timeout. I also preinitialize the pool. I see that the 10 instances are created upon startup but when the service is used the instances get d… --- ## [What could be the reason why BeforeExecutingGetDataReader event unsubscribe does not work](https://talk.remobjects.com/t/what-could-be-the-reason-why-beforeexecutinggetdatareader-event-unsubscribe-does-not-work/33893)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 10\ **Last updated:** [August 31, 2026, 3:18pm UTC](https://talk.remobjects.com/t/what-could-be-the-reason-why-beforeexecutinggetdatareader-event-unsubscribe-does-not-work/33893 "2026-08-31T15:18:23Z")
I have another peculiar issue on my RO/DA server side which occurs very infrequent. I have a RO service (SyncMasterService) with A DA service schema attached to it I log all SQL calls by using the RO/DA events I use a… --- ## [Delphi 13.1 - RODA 10.0.0.1627 - Generating interface files](https://talk.remobjects.com/t/delphi-13-1-roda-10-0-0-1627-generating-interface-files/33882)
**Author:** [@Filip\_Lagrou](https://talk.remobjects.com/u/Filip_Lagrou)\ **Replies:** 1\ **Last updated:** [August 28, 2026, 11:50am UTC](https://talk.remobjects.com/t/delphi-13-1-roda-10-0-0-1627-generating-interface-files/33882 "2026-08-28T11:50:47Z")
Installed RODA 10.0.0.1627. Having a RODL server with a struct “UserInfoEx” - ancestor “UserInfo”. (Re)Generating the interface-file creates methods using the private field variables (ReadComplex) like Self.fPrivileges … --- ## [After & BeforeProcessChange not triggering](https://talk.remobjects.com/t/after-beforeprocesschange-not-triggering/33863)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 4\ **Last updated:** [August 26, 2026, 3:57pm UTC](https://talk.remobjects.com/t/after-beforeprocesschange-not-triggering/33863 "2026-08-26T15:57:21Z")
What could be the reason why BeforeProcessChange & AfterProcessChange are not called by RO/DA? I have C# .NET code with a framework to trigger business rules This works fine for all the daschemas in a certain RO servic… --- ## [Install "DataAbstract" postgres driver missing PostgresDAC37](https://talk.remobjects.com/t/install-dataabstract-postgres-driver-missing-postgresdac37/33854)
**Author:** [@rposeikacbauto](https://talk.remobjects.com/u/rposeikacbauto)\ **Replies:** 1\ **Last updated:** [August 26, 2026, 8:20am UTC](https://talk.remobjects.com/t/install-dataabstract-postgres-driver-missing-postgresdac37/33854 "2026-08-26T08:20:26Z")
Delphi 13.1 Never tried the POSTGRES before. Cannot build, compile or install DataAbstract\_PostgresDACDriver\_D37 = says missing PostgresDAC37.dcp (Other drivers can be installed) Thank you in advance --- ## [Unexpected newlines when converting DASQAL.Expression to string](https://talk.remobjects.com/t/unexpected-newlines-when-converting-dasqal-expression-to-string/33851)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 3\ **Last updated:** [August 25, 2026, 12:18pm UTC](https://talk.remobjects.com/t/unexpected-newlines-when-converting-dasqal-expression-to-string/33851 "2026-08-25T12:18:01Z")
The remobjects code adds newlines in an SQL query which breaks the where expression I have a MSSQL DASSQL.Expression which looks good but the ToString() function adds newlines in the string constant. Is this a bug? --- ## [Can this complex DA schema SQL get to work with linq?](https://talk.remobjects.com/t/can-this-complex-da-schema-sql-get-to-work-with-linq/33790)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 3\ **Last updated:** [August 21, 2026, 8:29am UTC](https://talk.remobjects.com/t/can-this-complex-da-schema-sql-get-to-work-with-linq/33790 "2026-08-21T08:29:13Z")
I have a daschema with the sql statement you see below. I cannot get this to work with linq however Without UseDynamicWhere=true I get an error because of select \* from (with .... With that statement I get I don’t… --- ## [Issue with LINQ / SQL - how to investigate](https://talk.remobjects.com/t/issue-with-linq-sql-how-to-investigate/33817)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 1\ **Last updated:** [August 17, 2026, 12:50pm UTC](https://talk.remobjects.com/t/issue-with-linq-sql-how-to-investigate/33817 "2026-08-17T12:50:38Z")
I have a relative simple DA schema which results in an exception when performing a simple LINQ query DA schema: SELECT kor\_primkey, kor\_datechanged,kor\_userid, kor\_pat\_primkey, kor\_KortBtw1, kor\_KortBtw2, kor\_KortBt… --- ## [Is there an AfterExecutingGetDataReader or something similar?](https://talk.remobjects.com/t/is-there-an-afterexecutinggetdatareader-or-something-similar/33818)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 4\ **Last updated:** [August 17, 2026, 11:54am UTC](https://talk.remobjects.com/t/is-there-an-afterexecutinggetdatareader-or-something-similar/33818 "2026-08-17T11:54:51Z")
Is there something like AfterExecutingGetDataReader which accompanies BeforeExecutingGetDataReader which could be used to log duration and possibly success/error? For non-LINQ calls I have my logging in GetData but for… --- ## [Changing DA schema SQL statement before linq query execution](https://talk.remobjects.com/t/changing-da-schema-sql-statement-before-linq-query-execution/33789)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 14\ **Last updated:** [August 13, 2026, 4:51pm UTC](https://talk.remobjects.com/t/changing-da-schema-sql-statement-before-linq-query-execution/33789 "2026-08-13T16:51:31Z")
I would like to alter the SQL SELECT statement in a DA schema before execution with linq. More specifically I would like to alter several table names I have a .NET RO/DA server with a DA service. On the server side I … --- ## [Should orderby work with linq & UseDynmaicWhere=true when you use the {orderby} variable?](https://talk.remobjects.com/t/should-orderby-work-with-linq-usedynmaicwhere-true-when-you-use-the-orderby-variable/33791)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 3\ **Last updated:** [August 13, 2026, 1:24pm UTC](https://talk.remobjects.com/t/should-orderby-work-with-linq-usedynmaicwhere-true-when-you-use-the-orderby-variable/33791 "2026-08-13T13:24:42Z")
Should orderby work with linq & UseDynamicWhere=true when you use the {orderby} variable? I get error for a query that does orderby & has UseDynamicWhere=true even when I add {orderby} to the daschema sql --- ## [When is it safe to use GetBuffer() of Remobjects.SDK.Binary buffer - Avoiding error "MemoryStream's internal buffer cannot be accessed"](https://talk.remobjects.com/t/when-is-it-safe-to-use-getbuffer-of-remobjects-sdk-binary-buffer-avoiding-error-memorystreams-internal-buffer-cannot-be-accessed/33714)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 1\ **Last updated:** [July 30, 2026, 11:16am UTC](https://talk.remobjects.com/t/when-is-it-safe-to-use-getbuffer-of-remobjects-sdk-binary-buffer-avoiding-error-memorystreams-internal-buffer-cannot-be-accessed/33714 "2026-07-30T11:16:51Z")
I have a RemObjects.SDK.Type.Binary object of size 31MB and when I call the GetBuffer() function it throws exception “MemoryStream’s internal buffer cannot be accessed”. The Binary object was created using a byte\[\] arra… --- ## [Is there a way to convert the TableRequestInfoV5 whereclause XML into an SQL where clause manually](https://talk.remobjects.com/t/is-there-a-way-to-convert-the-tablerequestinfov5-whereclause-xml-into-an-sql-where-clause-manually/33708)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 10\ **Last updated:** [July 30, 2026, 7:44am UTC](https://talk.remobjects.com/t/is-there-a-way-to-convert-the-tablerequestinfov5-whereclause-xml-into-an-sql-where-clause-manually/33708 "2026-07-30T07:44:29Z")
Is there a way to convert the TableRequestInfoV5 whereclause XML into an SQL where clause manually For some cloud server purpose I need to manually process the WhereClause in TableRequestInfoV5 I would need to translat… --- ## [With Delphi 13 patch 1 is needed to update Data Abstract from version 10.0.0.1621 to 10.0.0.1627?](https://talk.remobjects.com/t/with-delphi-13-patch-1-is-needed-to-update-data-abstract-from-version-10-0-0-1621-to-10-0-0-1627/33629)
**Author:** [@Anderson\_Gregorio](https://talk.remobjects.com/u/Anderson_Gregorio)\ **Replies:** 6\ **Last updated:** [July 15, 2026, 6:31pm UTC](https://talk.remobjects.com/t/with-delphi-13-patch-1-is-needed-to-update-data-abstract-from-version-10-0-0-1621-to-10-0-0-1627/33629 "2026-07-15T18:31:00Z")
Hi That Delphi update was released on March 18, 2026. Is necessary update all remobjects components to new version to suport it? I’m having issues while generating “Library\_Invk.pas” Thank you. --- ## [TROIndyTCPChannel vs TROSuperTcpChannel vs TROSynapseSuperTCPChannel](https://talk.remobjects.com/t/troindytcpchannel-vs-trosupertcpchannel-vs-trosynapsesupertcpchannel/33469)
**Author:** [@marcantheunis](https://talk.remobjects.com/u/marcantheunis)\ **Replies:** 3\ **Last updated:** [June 5, 2026, 8:10am UTC](https://talk.remobjects.com/t/troindytcpchannel-vs-trosupertcpchannel-vs-trosynapsesupertcpchannel/33469 "2026-06-05T08:10:53Z")
question about the difference between channels, which one is to be preferred (LAN use) i’m reevaluating the core DA configs and although we supports almost all channels configurable, we rely on the plain TROSuperTcpChan… --- ## [Is there a drawback on having multiple datastreamers](https://talk.remobjects.com/t/is-there-a-drawback-on-having-multiple-datastreamers/33461)
**Author:** [@marcantheunis](https://talk.remobjects.com/u/marcantheunis)\ **Replies:** 9\ **Last updated:** [June 4, 2026, 9:49am UTC](https://talk.remobjects.com/t/is-there-a-drawback-on-having-multiple-datastreamers/33461 "2026-06-04T09:49:01Z")
since dabin2streamer isn’t thread safe (afaik), and more data oriented tasks are done in threads, i’m considering giving every datamodule or derived table object it’s own datastreamer, so nothing will hinder something el… --- ## [Forcing a field to update for delta updates](https://talk.remobjects.com/t/forcing-a-field-to-update-for-delta-updates/33433)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 2\ **Last updated:** [May 26, 2026, 10:54am UTC](https://talk.remobjects.com/t/forcing-a-field-to-update-for-delta-updates/33433 "2026-05-26T10:54:35Z")
I am using a RO DataTable to view and edit a DB table At the same time however I perform DB stored procedures which modify the some if the same fields. I am now running into an issue that my ApplyUpdates does not updat… --- ## [RemObjects SDK, DataAbstract fot .NET - Core VS2026](https://talk.remobjects.com/t/remobjects-sdk-dataabstract-fot-net-core-vs2026/33237)
**Author:** [@Chronicle](https://talk.remobjects.com/u/Chronicle)\ **Replies:** 4\ **Last updated:** [April 17, 2026, 1:13pm UTC](https://talk.remobjects.com/t/remobjects-sdk-dataabstract-fot-net-core-vs2026/33237 "2026-04-17T13:13:43Z")
I am unable to update my client files in Visual Studio 2026. Do I really need to install Visual Studio 2022 to update my client .rodl, .intf files. What are my options here? --- ## [daSchema daConnections no connection in daConnections](https://talk.remobjects.com/t/daschema-daconnections-no-connection-in-daconnections/33226)
**Author:** [@Wouter\_Devos1](https://talk.remobjects.com/u/Wouter_Devos1)\ **Replies:** 4\ **Last updated:** [April 17, 2026, 11:12am UTC](https://talk.remobjects.com/t/daschema-daconnections-no-connection-in-daconnections/33226 "2026-04-17T11:12:16Z")
Hello, When we open daSchema by double clicking the .daSchema file, the daConnections file opens as well, but it’s empty. So nothing works in daSchema. If we open the daConnections file by double clicking the .daConnec… --- ## [Why use IROStrings for WideMemo and how to disable USE\_IROSTRINGS\_FOR\_WIDEMEMO?](https://talk.remobjects.com/t/why-use-irostrings-for-widememo-and-how-to-disable-use-irostrings-for-widememo/33235)
**Author:** [@JohnRiche](https://talk.remobjects.com/u/JohnRiche)\ **Replies:** 3\ **Last updated:** [April 16, 2026, 3:13pm UTC](https://talk.remobjects.com/t/why-use-irostrings-for-widememo-and-how-to-disable-use-irostrings-for-widememo/33235 "2026-04-16T15:13:19Z")
I fail to understand the need to use IROStrings by default for WideMemo fields as the IROStrings.Text property will always return the text value with an additional trailing #13#10 which wasn’t in the original content. I… --- ## [Null value in Statements.Find](https://talk.remobjects.com/t/null-value-in-statements-find/33198)
**Author:** [@Wouter\_Devos1](https://talk.remobjects.com/u/Wouter_Devos1)\ **Replies:** 2\ **Last updated:** [April 15, 2026, 9:09am UTC](https://talk.remobjects.com/t/null-value-in-statements-find/33198 "2026-04-15T09:09:47Z")
Hello, We have a legacy .NET Framework application. Everything works fine until version 10.0.0.1599. Starting version 10.0.0.1605 we have an error in the override of ProcessDelta (it’s very old code…). The error happens… --- ## [Issue with delta values for reduced delta in case business rule triggered](https://talk.remobjects.com/t/issue-with-delta-values-for-reduced-delta-in-case-business-rule-triggered/33093)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 40\ **Last updated:** [April 2, 2026, 1:20pm UTC](https://talk.remobjects.com/t/issue-with-delta-values-for-reduced-delta-in-case-business-rule-triggered/33093 "2026-04-02T13:20:10Z")
I have an issue with the delta set that gets passed to the Update RO call After a first ApplyUpdates which fails due to a server side business rule it looks like the fields are scrambled a bit In my TProductDetailServe… --- ## [Array bounds issue - where to look](https://talk.remobjects.com/t/array-bounds-issue-where-to-look/33127)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 12\ **Last updated:** [March 27, 2026, 9:04am UTC](https://talk.remobjects.com/t/array-bounds-issue-where-to-look/33127 "2026-03-27T09:04:27Z")
I have a delphi DA client and a .NET DA server. When I append to the dataset I get an “index was outside the bounds of the array” error thrown bt the ApplyUpdates. My DA schema appears OK, my strongly typed delphi s… --- ## [Where and when do i correctly add a macro in my DAService](https://talk.remobjects.com/t/where-and-when-do-i-correctly-add-a-macro-in-my-daservice/33122)
**Author:** [@marcantheunis](https://talk.remobjects.com/u/marcantheunis)\ **Replies:** 11\ **Last updated:** [March 27, 2026, 6:25am UTC](https://talk.remobjects.com/t/where-and-when-do-i-correctly-add-a-macro-in-my-daservice/33122 "2026-03-27T06:25:24Z")
i defined a macro that will help create the sql being constructed in my DAService i found some old post that said to add the function in the DataAbstractServiceAfterAcquireConnection event, but it seems that that one is… [Next page](https://talk.remobjects.com/c/da/3.md?page=1)