I've been stuck trying to make a simple update query work (like was totally possible with MS Access) in a Mobile Geodatabase and getting the "no such function: UpdateInde圎ntry" error. Super important disclaimers noted here that ESRI should be making public to potential users of SQLite made from Pro. Thanks for the valuable information in this thread. Support requirement is for offline users who are often working with no internet connection. This kind of functionality is also something we are hoping someday extends to file geodatabases as well. Ideal solution would be one where scheduling or manually running a single SQL script to run on the database would handle the weekly data update. SET columnX = (SELECT columnY FROM table2 WHERE lumn1 = lumn1) Īs a precursor to this we run an unmatched query using a left out join to determine what data gets sent to the API for return with new field data for update/integration into the SQLite DB. The SQL is fairly basic, summarized in this example: And magnitudes of time slower in performance than acting directly on the database through SQL. Again extra steps when SQLite can handle the entire process with 2 lines of SQL code already. Extra steps using extra tools as a workaround to functionality that should already be available in SQLite and is available in the non-ESRI SQlite.Īlternatively, using ESRI tools to create a permanent table join, perform table update in python, delete extra fields works. SQL logic works fine if we take the extra step of moving the data from the mobile geodatabase to an enterprise geodatabase and then moving it back. Update query later performed to add certain values from the returned table to certain rows in the spatial table based upon a non-spatial table join and a where clause. We then import that table using ESRI tools into a database. We bang the entire dataset up against a 3'rd party API which returns a new data table containing the results of the bangup. It's a non-spatial table edit that's not working. In my case it's not a spatial function thats needed though.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |