Skip to content
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

Insert entityreference problem #133

Closed
michalhainc opened this issue Dec 1, 2021 · 2 comments · Fixed by #134
Closed

Insert entityreference problem #133

michalhainc opened this issue Dec 1, 2021 · 2 comments · Fixed by #134

Comments

@michalhainc
Copy link

Hi,

thank you for fantastic tool,

I have a problem after last update (I would say this query worked last week, but not entirely sure though)

I'm running version 5.3.0.0, connecting to d365 online

I wanted to insert a note using this query

insert into annotation (subject, filename, documentbody, mimetype, objectid, objectidtype) values ('mha test 1','abc.txt', 'YWJj', 'text/plain', '42e37c3b-8252-ec11-8c62-00224802c5b9','account');

I'm getting an error:
No implicit type conversion from System.Data.SqlTypes.SqlString to MarkMpn.Sql4Cds.Engine.SqlEntityReference: objectid

Do I need some special format to insert the entity reference field?
Am I doing something wrong?

Thanks

@MarkMpn
Copy link
Owner

MarkMpn commented Dec 1, 2021

Thanks, I think this is related to #131. I'm hoping to get a new version out in the next day or two to fix this.

MarkMpn added a commit that referenced this issue Dec 1, 2021
@michalhainc
Copy link
Author

Thanks for info

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants