topic Re: Field Calculator and Base Tables in Data Management Questions

Field Calculator and Base Tables

LauraCarr — Thu, 02 Dec 2010 21:05:35 GMT

Hi All,
Does anyone know when using the Field Calculator in ArcMap, does that make the modifications to the A & D tables in ArcSDE or to the Base tables?

I ask because we used the Field Calculator, hit Save Edits and then the Conflicts window appeared. Generally you only get this after you have performed a reconcile - which had NOT been done.

We are using ArcMap version 9.3.1 and ArcSDE 9.3.1 in SQL Server 2008.

Thanks,
Laura

Re: Field Calculator and Base Tables

VinceAngelo — Fri, 03 Dec 2010 11:19:29 GMT

Edits to a versioned table, even one set to "move edits to base", go through the A/D tables.

I once had a customer who was tweaking network weighting values on a large (200k rows)
table and was complaining about poor performance -- If turns out they had 30 million rows
in both the An and Dn tables. I recommended they put modeling constants in a joined table,
one edited with an ODBC connection.

- V