Share
Report
14Hello
I have existing DB on SQL server and created Dataverse Virtual tables through new interface. The SQL tables have bit fields, which do not update properly from Dataverse/Canvas app. All boolean values get set to true, no matter what the input is.
Cavas app patch function though virtual table - false turns to true during insert/update. Monitor shows request was sent with correct false values, but response was all boolean 'true'. No errors raised.
Direct edit on Virtual table in dataverse - false turns to true
If I update a row in SQL server directly, shows false/true as required in Virtual table. Update on such field in virtual table breaks the value again (one set to true, cannot be set to false again).
Canvas app patch fuction through SQL connection to same table of SQL server - false remains false, works as required.
So the issue seems to be for Virtual table only! Once insert/update is initiated through virtual table, the virtual table does not update to false anymore.
Is there a fix for this?
Thank you!
All responses (
Answers (
