Select to view content in your preferred language

Does SQL View provide updated data & include changes which are made(committed) in Pro but not yet saved?

448
0
12-18-2023 04:38 AM
Labels (2)
AnkushMadankar
New Contributor

I have Enterpriser SQL Sever Connection as Geodatabase (ArcGIS PRO 3.1). This database has SQL View with few joins. I am using this view to load data in lookup/dropdown. I have few issues related to data been fetch and displayed after few edits been made to map until user save the edits. I suspect SQL View does not provide updated data from joined table which are been edited but not saved, whereas individual table provide updated edit data.

Sample code:

 

var queryTableDescription = new QueryTableDescription(new QueryDef { Tables = "ViewName"} );
var queryTable = geodatabase.OpenQueryTable(queryTableDescription);
var data = queryTable.Search();

 

Please anyone could confirm this behaviour?

Thanks in advance!

Tags (1)
0 Replies