CreateRow skipping sequential objectid's on insert
540
3
02-07-2023 11:03 AM
by
Creating a custom pane addin for editing a table of values. However, the objectid's of the added values are far off from being the next number. For example, it goes from 405 to 801:
After truncating the table and restarting at 303, it goes to 705, then 1506:
Using the recommended process for creating a row in a table:
try
{
EditOperation editOperation = new EditOperation();
await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() =>
{
using (Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(new Uri(App_paths.AsrCntyConnection))))
using (Table UnlistedEdit = geodatabase.OpenDataset<Table>("db.sde.unlisted"))
{
editOperation.Callback(context =>
{
using (RowBuffer rowBuffer = UnlistedEdit.CreateRowBuffer())
{
try
{
rowBuffer["accountno"] = unlistedaccount.AccountNo;
rowBuffer["name1"] = unlistedaccount.OwnerName;
using (Row row = UnlistedEdit.CreateRow(rowBuffer))
{
// To Indicate that the attribute table has to be updated.
context.Invalidate(row);
}
}
catch (GeodatabaseException exObj)
{
updteResults = false;
System.Diagnostics.Debug.WriteLine($"Failed while inserting account for {unlistedaccount.AccountNo}", exObj);
}
}
}, UnlistedEdit);
try
{
updteResults = editOperation.Execute();
if (!updteResults) message = editOperation.ErrorMessage;
}
catch (GeodatabaseException exObj)
{
message = exObj.Message;
}
return updteResults;
}
});
}
catch (GeodatabaseFieldException fieldException)
{
updteResults = false;
System.Diagnostics.Debug.WriteLine($"Field Exception while inserting account for {unlistedaccount.AccountNo}", fieldException);
}
catch (Exception exception)
{
updteResults = false;
System.Diagnostics.Debug.WriteLine($"Exception while inserting account for {unlistedaccount.AccountNo}", exception);
}
return updteResults;Before reporting this as a bug, anyone else see this behavior/ issue?
