Sql4Cds
Sql4Cds copied to clipboard
Unable to run a query after recent update
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 = 'Role' and msdyn_componentid = '155A0C01-FD75-EA11-A811-000D3A33F11E' and msdyn_solutionname = 'Active'
Cannot convert object of type 'System.Data.SqlTypes.SqlGuid' to object of type 'System.Data.SqlTypes.SqlString'.Couldn't store <155a0c01-fd75-ea11-a811-000d3a33f11e> in msdyn_componentid Column. Expected type is SqlString. Cannot convert object of type 'System.Data.SqlTypes.SqlGuid' to object of type 'System.Data.SqlTypes.SqlString'.
Any idea how to resolve?
Can you confirm the version of SQL 4 CDS you're running please?
@MarkMpn, 5.4.0.0 thank you
Interesting, I think this is a bug in either the metadata for this entity or the underlying data provider. I've raised an issue for this at https://github.com/MicrosoftDocs/powerapps-docs/issues/2974
@MarkMpn , thank you for responding so quickly and opening the issue with Microsoft. Looking forward to their response.