Tag Info

New answers tagged

0

You can only write such SQL if you use Personal Geodatabase (ACCESS) and if you open the geodatabase in Access. In this case you can use the IIF function as follows: iif ( condition, value_if_true, value_if_false ) Here is an example. You can't use full featured SQL using Personal Geodatabases in ArcGIS Desktop, only limited SQL-like expressions to ...


2

I suggest this: SELECT TOP 3 * FROM MyTable WHERE NOT [Field2] = '%Variable%' ORDER BY [Field1] Example Let's start with an unordered table: +------------------+------------+ | rainbow_sequence | color_name | +------------------+------------+ | 2 | orange | | 3 | yellow | | 1 | red | | ...


0

The easiest way would be to enable editor tracking. You would be able to see what was edited, who edited it, what day and time it was edited. Editor tracking creates four new columns, however. The other way would be to write a database trigger to populate a column or table any time a insert or update is made on the feature class. You could populate the ...



Top 50 recent answers are included