Sql4Cds
Sql4Cds copied to clipboard
SQL 4 CDS core engine and XrmToolbox tool
More than once lately, I've wanted to get a `SELECT *` from a table in my CDS - but really only for the custom columns that I've added - leaving...
Option to allow updating or deleting records without retrieving them first if the IDs are provided: ```sql UPDATE account SET name = 'value' WHERE accountid = 'id' ```
Should be able to: * retrieve content of a file attribute as well as just the ID * insert/update values by: * copying existing values, * parameterised blob values, or...
Hi Mark, thank you for the great plugin. I've been using it extensively. I noticed that the following query produces an error: select top 100 * from msdyn_componentlayer where msdyn_solutioncomponentname...
I can't imagine this being a major issue for most people, and there is a workaround for this, but if you drag a query editor window outside of the Toolbox,...
They say a picture is worth a thousand words, and I'd rather not type that many (also I think this picture explains the problem pretty well): ![evidence](https://github.com/MarkMpn/Sql4Cds/assets/48190250/87062521-4361-4f77-a561-f1d324567884) I suspect that...
Hi, When I try to run this query ``` select top 10 W2.name from webresource W2 where NOT EXISTS ( select TOP 10 W.webresourceid from webresource W inner join solutioncomponent...
Triggered from #468, currently the parameters are ordered by `sdkmessagerequestfield.position` however for CustomAPIs the position isn't included in solution exports; resulting in the position following solution imports coming through "randomly"....