Posts

The query operation has exceeded the maximum row size of SQL Server.

Image
You got something like: The query operation has exceeded the maximum row size of SQL Server. Please reduce the number of columns or joined tables.  The reason for this is that the form-query structure is too large. For example:  One way to address this is by reducing the number of fields, as you likely don't need all of the included fields. However, some coding adjustments will be necessary: Override init for each data source: I only need to display two specific fields out of the hundreds available here: Repeat for next Data source..

How to Update a Table Using SysDa Classes

Image
SysDa classes may seem complex at first, but once you start using them, you'll realize how logical and well-structured the framework actually is. In this real-life example, I needed to update a single field using a LIKE condition. And look how you can combine AND and OR clauses to refine your query logic: More information about SysDa: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/sysda