-
Notifications
You must be signed in to change notification settings - Fork 16
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Unable to run a query after recent update #152
Comments
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. |
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?
The text was updated successfully, but these errors were encountered: