Describe the bug
When trying to run UPDATE query
UPDATE dbo.dpp_dppdocumentdata
SET dpp_documenttype = dpp_documenttype
WHERE dpp_document = '0611516d-a6a5-4b43-9cb0-c400530ec98a'
SQL4CDS rejects to execute with error
Invalid column name 'dpp_documenttype'.
Even if I am 100% sure column with this name exists (I double checked this by running query:
select * from metadata.attribute
where entitylogicalname = 'dpp_dppdocumentdata'
and logicalname = 'dpp_documenttype'
and this query returns single column
To Reproduce
I believe this is unique for my setup - I am just looking way of deeper troubleshooting this on my side.
Expected behavior
Properly accepting existing columns for a table
Screenshots

Environment (please complete the following information):
Microsoft Dataverse - 9.2.25032.214
SQL 4 CDS - 9.6.0.0
Mar 31 2025 08:36:28
Copyright © 2020 - 2024 Mark Carrington
Additional context
I have column with same name (and type - this is Text column) in other Entity / Table - and there similar query works fine
I compared configuration for 2 columns using Metadata Browser tool - I see no differences between columns (1 that works and 1 that does not work) - so to me this looks like mystery
Describe the bug
When trying to run UPDATE query
SQL4CDS rejects to execute with error
Invalid column name 'dpp_documenttype'.
Even if I am 100% sure column with this name exists (I double checked this by running query:
and this query returns single column
To Reproduce
I believe this is unique for my setup - I am just looking way of deeper troubleshooting this on my side.
Expected behavior
Properly accepting existing columns for a table
Screenshots
Environment (please complete the following information):
SQL 4 CDS edition: XrmToolBox
Results of
SELECT @@VERSION:Additional context
I have column with same name (and type - this is Text column) in other Entity / Table - and there similar query works fine
I compared configuration for 2 columns using Metadata Browser tool - I see no differences between columns (1 that works and 1 that does not work) - so to me this looks like mystery