Skip to content

[BUG] SQL4CDS Update query does not accept existing and valid attribute #661

Description

@PRusakPL

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

Image

Environment (please complete the following information):

  • SQL 4 CDS edition: XrmToolBox

  • Results of SELECT @@VERSION:

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions