# Data Abstract **URL:** https://talk.remobjects.com/c/da/3.md?page=3 [Latest](https://talk.remobjects.com/latest.md) · [Categories](https://talk.remobjects.com/categories.md) · [Tags](https://talk.remobjects.com/tags.md) **Page:** 4 --- ## [Issue with database connection since upgrade to RO 10.0.0.1597 - Invalid object name 'dbo.XXX'](https://talk.remobjects.com/t/issue-with-database-connection-since-upgrade-to-ro-10-0-0-1597-invalid-object-name-dbo-xxx/31238)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 12\ **Last updated:** [December 24, 2024, 12:19pm UTC](https://talk.remobjects.com/t/issue-with-database-connection-since-upgrade-to-ro-10-0-0-1597-invalid-object-name-dbo-xxx/31238 "2024-12-24T12:19:26Z")
I recently upgraded to RO 10.0.0.1597 and while all code appeared to work I notice some DA4 RO DA services don’t work properly anymore It looks like the DB connection associated with the service is not pointing to the … --- ## [Incorrect dataparameter type in the update and insert calls](https://talk.remobjects.com/t/incorrect-dataparameter-type-in-the-update-and-insert-calls/31228)
**Author:** [@is2software](https://talk.remobjects.com/u/is2software)\ **Replies:** 2\ **Last updated:** [December 19, 2024, 3:48pm UTC](https://talk.remobjects.com/t/incorrect-dataparameter-type-in-the-update-and-insert-calls/31228 "2024-12-19T15:48:33Z")
We are having some errors on updates and inserts where the parameter datatype is incorrect. Where or what function is called in DataAbstract to assign the datatype, etc for the data parameters for the sql statement? Th… --- ## [Is the DA3 delta data different from DA4 data - Can a DA3 delta be passed on to a DA4 server](https://talk.remobjects.com/t/is-the-da3-delta-data-different-from-da4-data-can-a-da3-delta-be-passed-on-to-a-da4-server/31208)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 2\ **Last updated:** [December 16, 2024, 3:41pm UTC](https://talk.remobjects.com/t/is-the-da3-delta-data-different-from-da4-data-can-a-da3-delta-be-passed-on-to-a-da4-server/31208 "2024-12-16T15:41:00Z")
I have a lot of legacy DA3 data (delphi DA3 server) I want to do additional processing of data changes in another DA4 (.NET) server. Can I pass the Binary from UpdateData to the DA4 server? I tried this but I get an e… --- ## [Bypass maximum number of parameters](https://talk.remobjects.com/t/bypass-maximum-number-of-parameters/31172)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 11\ **Last updated:** [December 16, 2024, 11:58am UTC](https://talk.remobjects.com/t/bypass-maximum-number-of-parameters/31172 "2024-12-16T11:58:15Z")
I use a huge amount of parameters for certain (maintenance) queries However I run into a limitation of RO/DA Is there a way to bypass this? It’s used as an ‘IN’ SQL where clause. var listWhereExpression = new List\ **Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 8\ **Last updated:** [December 9, 2024, 2:08pm UTC](https://talk.remobjects.com/t/run-custom-sql-to-fetch-scalar-value-from-ro-da-service/31166 "2024-12-09T14:08:07Z") I want to add functionality to easily fetch scalar data from a service using custom SQL. I implemented a client side function: public static T GetScalarValueWithCustomSQL\(IDataAbstractService service,string sql) whe… --- ## [Delphi DataAbstract and REST](https://talk.remobjects.com/t/delphi-dataabstract-and-rest/31152)
**Author:** [@is2software](https://talk.remobjects.com/u/is2software)\ **Replies:** 6\ **Last updated:** [December 6, 2024, 3:20pm UTC](https://talk.remobjects.com/t/delphi-dataabstract-and-rest/31152 "2024-12-06T15:20:10Z")
Years ago, I asked about REST and DataAbstact. At that time, there was only the .Net example. Is there now an example of Delphi DataAbstract with REST? Or an example of Delphi RO using REST with database tables? I … --- ## [DataParameter in SQL is not what is specified in call because of bad automatic datatype detection of the DA schema modeler](https://talk.remobjects.com/t/dataparameter-in-sql-is-not-what-is-specified-in-call-because-of-bad-automatic-datatype-detection-of-the-da-schema-modeler/31153)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 1\ **Last updated:** [December 4, 2024, 7:34pm UTC](https://talk.remobjects.com/t/dataparameter-in-sql-is-not-what-is-specified-in-call-because-of-bad-automatic-datatype-detection-of-the-da-schema-modeler/31153 "2024-12-04T19:34:35Z")
I just spent more than half a day investigating a very weird issue with DA 10.0.0.1597 I let DA perform a GetData with 2 int parameters: @dynNL & @dynFR The server logs the request and in the log I see the correct va… --- ## [DA JavaScript](https://talk.remobjects.com/t/da-javascript/31099)
**Author:** [@Filip\_Lagrou](https://talk.remobjects.com/u/Filip_Lagrou)\ **Replies:** 4\ **Last updated:** [December 3, 2024, 12:19pm UTC](https://talk.remobjects.com/t/da-javascript/31099 "2024-12-03T12:19:38Z")
Hi We needed to adjust the DataAbstract.js for further implementation in Delphi web-applications. Maybe this is necessary in an update of DA for JavaScript. // RemoteDataAdapter : function RemoteDataAdapter(aDataSe… --- ## [Generate Schema strongly-type access units can't be compiled](https://talk.remobjects.com/t/generate-schema-strongly-type-access-units-cant-be-compiled/31049)
**Author:** [@tstoicescu](https://talk.remobjects.com/u/tstoicescu)\ **Replies:** 3\ **Last updated:** [November 25, 2024, 12:33pm UTC](https://talk.remobjects.com/t/generate-schema-strongly-type-access-units-cant-be-compiled/31049 "2024-11-25T12:33:49Z")
Hello, With the last version 10.0.0.1599 source generated with “Generate Schema strongly-type access units” ide command can’t be compiled. For commands, params are generated with DataType Unknown. On the older version… --- ## [How do you use BeforeProcessChange DeltaChangeEventArgs.CanRemove in business processor](https://talk.remobjects.com/t/how-do-you-use-beforeprocesschange-deltachangeeventargs-canremove-in-business-processor/31019)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 4\ **Last updated:** [November 21, 2024, 8:02am UTC](https://talk.remobjects.com/t/how-do-you-use-beforeprocesschange-deltachangeeventargs-canremove-in-business-processor/31019 "2024-11-21T08:02:40Z")
How do you prevent an update (delete) via business processors? I found the CanRemove property in DeltaChangeEventArgs and specified that in my BP if (e.DeltaChange.Type == RemObjects.DataAbstract.ChangeType.Delete) { … --- ## [TableRequestInfo.UserFilter for .NET RO/DA server](https://talk.remobjects.com/t/tablerequestinfo-userfilter-for-net-ro-da-server/31017)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 4\ **Last updated:** [November 20, 2024, 9:52am UTC](https://talk.remobjects.com/t/tablerequestinfo-userfilter-for-net-ro-da-server/31017 "2024-11-20T09:52:45Z")
How do you use TableRequestInfo.UserFilter for a .NET RO/DA service? Putting SQL in there does not do anything. Documentation states it is disabled by default (TableRequest Object) Our delphi code sets service.Allowu… --- ## [How To Specify The Database In Sql Query](https://talk.remobjects.com/t/how-to-specify-the-database-in-sql-query/31010)
**Author:** [@is2software](https://talk.remobjects.com/u/is2software)\ **Replies:** 3\ **Last updated:** [November 15, 2024, 3:43pm UTC](https://talk.remobjects.com/t/how-to-specify-the-database-in-sql-query/31010 "2024-11-15T15:43:38Z")
Just ran into this as a production problem. We need to pull data from one database table into another table on a completely different database. Two separate databases but this could be from any of the 7 that are ope… --- ## [Delete record in RO/DA service with business rules trigger](https://talk.remobjects.com/t/delete-record-in-ro-da-service-with-business-rules-trigger/31009)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 1\ **Last updated:** [November 15, 2024, 6:45am UTC](https://talk.remobjects.com/t/delete-record-in-ro-da-service-with-business-rules-trigger/31009 "2024-11-15T06:45:17Z")
I have some code in a RODA service on the server side to delete rows from a table that must execute the businessprocessor rules My code works but I achieve it by fetching the data from the DB. Is there a way to achive … --- ## [How To Turn Server Login On and Off](https://talk.remobjects.com/t/how-to-turn-server-login-on-and-off/31005)
**Author:** [@is2software](https://talk.remobjects.com/u/is2software)\ **Replies:** 1\ **Last updated:** [November 14, 2024, 8:10am UTC](https://talk.remobjects.com/t/how-to-turn-server-login-on-and-off/31005 "2024-11-14T08:10:00Z")
After the server is running or upon startup, how can we turn the login requirement on and off. This is for running the same server for design time field updating with login off and also for runtime with login back on. … --- ## [Schema Modeler Error on Closing (Invalid property type: TStrings)](https://talk.remobjects.com/t/schema-modeler-error-on-closing-invalid-property-type-tstrings/30979)
**Author:** [@kbripleyindcom](https://talk.remobjects.com/u/kbripleyindcom)\ **Replies:** 2\ **Last updated:** [November 9, 2024, 6:52pm UTC](https://talk.remobjects.com/t/schema-modeler-error-on-closing-invalid-property-type-tstrings/30979 "2024-11-09T18:52:35Z")
I am receiving error “Invalid property type: TStrings” when I close the schema modeler. My server project has several units which have schemas and none of them return this error. This error began to occur after instal… --- ## [Extract data from .dat files of an old delphi application](https://talk.remobjects.com/t/extract-data-from-dat-files-of-an-old-delphi-application/30960)
**Author:** [@silvered.dragon](https://talk.remobjects.com/u/silvered.dragon)\ **Replies:** 7\ **Last updated:** [November 4, 2024, 7:08pm UTC](https://talk.remobjects.com/t/extract-data-from-dat-files-of-an-old-delphi-application/30960 "2024-11-04T19:08:40Z")
Sure! Here’s the updated translation with your additional information included: Hello everyone, I’m a senior JS+PHP developer, but I have no experience with Delphi or Data Abstract. I have an old application in my com… --- ## [DA schema builder](https://talk.remobjects.com/t/da-schema-builder/29522)
**Author:** [@marcantheunis](https://talk.remobjects.com/u/marcantheunis)\ **Replies:** 11\ **Last updated:** [October 30, 2024, 10:34am UTC](https://talk.remobjects.com/t/da-schema-builder/29522 "2024-10-30T10:34:48Z")
hi, it would be handy if i just could alter the Log Changes checkbox in the Fields overview… now i have to select every individual field to uncheck Log Changes… i still suffer from a ‘connection’ error launching the sch… --- ## [Database Schemas - How To View On Server At RunTime](https://talk.remobjects.com/t/database-schemas-how-to-view-on-server-at-runtime/30911)
**Author:** [@is2software](https://talk.remobjects.com/u/is2software)\ **Replies:** 4\ **Last updated:** [October 28, 2024, 6:45am UTC](https://talk.remobjects.com/t/database-schemas-how-to-view-on-server-at-runtime/30911 "2024-10-28T06:45:25Z")
Using a custom Delphi DataAbstract Server, how could we view the Schema tables and fields during runtime to make sure we are using current loaded schema? How do we call the Schema and then list the tables and fields fr… --- ## [How can I detect when the server has disconnected a client connection?](https://talk.remobjects.com/t/how-can-i-detect-when-the-server-has-disconnected-a-client-connection/30866)
**Author:** [@simona](https://talk.remobjects.com/u/simona)\ **Replies:** 2\ **Last updated:** [October 1, 2024, 8:33am UTC](https://talk.remobjects.com/t/how-can-i-detect-when-the-server-has-disconnected-a-client-connection/30866 "2024-10-01T08:33:52Z")
I have a client application that is connecting to a DA server using IpSuperTcpClientChannel. Is there a way to detect when the server has disconnected the client following the timeout specified in MemorySessionManager.Ti… --- ## [How do I get the column name from a DeltaChange (NewValues row)](https://talk.remobjects.com/t/how-do-i-get-the-column-name-from-a-deltachange-newvalues-row/30836)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 2\ **Last updated:** [September 24, 2024, 11:46am UTC](https://talk.remobjects.com/t/how-do-i-get-the-column-name-from-a-deltachange-newvalues-row/30836 "2024-09-24T11:46:16Z")
I have a DeltaChange object where I need to process all values in the NewValues row. I need to identify the column name for each index. How do I obtain this column name? I am now using Delta.Schema.Fields but this lis… --- ## [Can SELECT FROM (SELECT be avoided when using linq for DA schema SQLs?](https://talk.remobjects.com/t/can-select-from-select-be-avoided-when-using-linq-for-da-schema-sqls/30799)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 1\ **Last updated:** [September 17, 2024, 8:52am UTC](https://talk.remobjects.com/t/can-select-from-select-be-avoided-when-using-linq-for-da-schema-sqls/30799 "2024-09-17T08:52:46Z")
I notice the select statement that gets executed by MS SQL is a SELECT FROM (SELECT Can this be avoided? I have a DA schema with following SQL When I execute var query = dataAdapter.GetTable\ **Author:** [@tobygroves](https://talk.remobjects.com/u/tobygroves)\ **Replies:** 8\ **Last updated:** [September 16, 2024, 1:47pm UTC](https://talk.remobjects.com/t/omitting-fields/30795 "2024-09-16T13:47:30Z") I’m probably being hopelessly optimistic here but is there any simple way of omitting certain fields when opening a data table? When I say “simple”, I mean without resorting to using dynamic select which is fraught with… --- ## [.NET linq access to DA table with parameters](https://talk.remobjects.com/t/net-linq-access-to-da-table-with-parameters/30775)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 6\ **Last updated:** [September 14, 2024, 1:30pm UTC](https://talk.remobjects.com/t/net-linq-access-to-da-table-with-parameters/30775 "2024-09-14T13:30:32Z")
Is there a way to add parameters to a LINQ DA call I have .NET code to fetch data from a dataabstract server var query = dataAdapter.GetTable\() .Where(x =\> x.rel\_type ==OffCloudClient… --- ## [Command parameter direction for stored procedure](https://talk.remobjects.com/t/command-parameter-direction-for-stored-procedure/30773)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 2\ **Last updated:** [September 12, 2024, 10:39am UTC](https://talk.remobjects.com/t/command-parameter-direction-for-stored-procedure/30773 "2024-09-12T10:39:40Z")
When I create a command in a daschema that’s based on an MS SQL stored procedure the parameter direction of an output parameter is set to InOut In the stored procedure the parameter is specified as out however. Is this… --- ## [.NET core client for RO DA service crashes in LinqRemoteDataAdapter](https://talk.remobjects.com/t/net-core-client-for-ro-da-service-crashes-in-linqremotedataadapter/30722)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 7\ **Last updated:** [September 6, 2024, 11:53am UTC](https://talk.remobjects.com/t/net-core-client-for-ro-da-service-crashes-in-linqremotedataadapter/30722 "2024-09-06T11:53:25Z")
We have a code base which is mostly .NET framework but we have new .NET core applications We use .NET projects to facilitate RO DA clients that are then project dependencies on the client side. The .NET projects are ta… --- ## [How To Build Design Time Reports If Using Joins](https://talk.remobjects.com/t/how-to-build-design-time-reports-if-using-joins/29995)
**Author:** [@is2software](https://talk.remobjects.com/u/is2software)\ **Replies:** 4\ **Last updated:** [August 26, 2024, 6:53am UTC](https://talk.remobjects.com/t/how-to-build-design-time-reports-if-using-joins/29995 "2024-08-26T06:53:28Z")
Using DataAbstract TDAMemTable and DASql, how should we do design time building of field list if we are using joins in the statement? The issue we are running into is the building of reports in ReportBuilder where we u… --- ## [DASchema and businessprocessor that fails to throw an exception](https://talk.remobjects.com/t/daschema-and-businessprocessor-that-fails-to-throw-an-exception/30614)
**Author:** [@marcantheunis](https://talk.remobjects.com/u/marcantheunis)\ **Replies:** 11\ **Last updated:** [August 15, 2024, 7:16am UTC](https://talk.remobjects.com/t/daschema-and-businessprocessor-that-fails-to-throw-an-exception/30614 "2024-08-15T07:16:29Z")
hi, i had a nasty problem where a DA schema table ‘lost’ the primary key property of a field (i guess as a result of an update to the fields cause i added some fields in the query) that said, the server side business p… --- ## [I have Issue with Data Abstract in .NET: Synchronization Errors](https://talk.remobjects.com/t/i-have-issue-with-data-abstract-in-net-synchronization-errors/30037)
**Author:** [@ew685283](https://talk.remobjects.com/u/ew685283)\ **Replies:** 1\ **Last updated:** [July 25, 2024, 11:40am UTC](https://talk.remobjects.com/t/i-have-issue-with-data-abstract-in-net-synchronization-errors/30037 "2024-07-25T11:40:53Z")
Hello guys! :smiling\_face\_with\_three\_hearts: I am using Data Abstract in a.NET project, and I am running into some synchronization issues that I can’t figure out how to fix. In my configuration, the client updates and r… --- ## [Create delphi pas file with constants for commands and command parameters from daschema](https://talk.remobjects.com/t/create-delphi-pas-file-with-constants-for-commands-and-command-parameters-from-daschema/30027)
**Author:** [@fvancrae](https://talk.remobjects.com/u/fvancrae)\ **Replies:** 9\ **Last updated:** [August 14, 2024, 2:51pm UTC](https://talk.remobjects.com/t/create-delphi-pas-file-with-constants-for-commands-and-command-parameters-from-daschema/30027 "2024-08-14T14:51:32Z")
Is there a way to generate a .pas file with constants for the commands and command parameters from a daschema (similar to what happens for the tables and table fields. I see this data is missing in the DASchemaClient\_In… --- ## [Odata resource asking for login and password (Insecure)](https://talk.remobjects.com/t/odata-resource-asking-for-login-and-password-insecure/30024)
**Author:** [@Anderson\_Gregorio](https://talk.remobjects.com/u/Anderson_Gregorio)\ **Replies:** 1\ **Last updated:** [July 23, 2024, 6:28am UTC](https://talk.remobjects.com/t/odata-resource-asking-for-login-and-password-insecure/30024 "2024-07-23T06:28:49Z")
Hi We’ve servers running behind some IPs, but this resource was pointed as insecure. Example: Opening in Chrome: 127.0.0.1/odata it asks for login and password. Is there a way to unable /odata resource? Follow: … [Previous page](https://talk.remobjects.com/c/da/3.md?page=2) [Next page](https://talk.remobjects.com/c/da/3.md?page=4)