Latest Contributions by LanceShipman

"[]" are unique to Access and SQL Server. They are not part of the SQL standard. ... View more

'Esri.FileGDBAPI.DLL' is the C# wrapper. Do you also copy  'FileGDBAPI.dll'? ... View more

At ArcGIS 10.1 you can use ArcObjects to rename a field in a geodatabase. It was not possible prior to 10.1. ... View more

Add your request to http://ideas.arcgis.com/ideaView?id=08730000000887yAAA on the idea site. ... View more

Thank you for all of the feedback on the file geodatabase API and OS X Mavericks. We are investigating our options and will be providing a solution as part of the next release of the API. The release date has not be set, but I expect it will be before the ESRI Dev Conference in March. ... View more

It appears that the available binary API is not compatible with the new OS X 10.9 Mavericks. Can anyone else confirm or deny this? I am unable to build gdal support for FileGDB, and I suspect it is due to changes in the available libs in 10.9 versus older OS versions. We will take a look. Can you provide more information. What errors are you seeing when you attempt to build gdal. ... View more

The needing to restart indicates that another process has a lock on the file geodatabase. A file geodatabase cannot be deleted id a lock is present. You should delete a file geodatabase from ArcGIS, not from the file system. Deleting a file geodatabase from the file system may leave some files on disk. Rather than rebooting you need to shut down the locking processes. From windows explorer look in the file geodatabase directory. You should see some files file a .lock extension. The file names include the process number. ... View more

Try setting the write lock after running the search.  rowsParcels = parcelTable.Search(firstColumn, parcelTableWhereClause, RowInstance.Recycle); parcelTable.SetWriteLock(); ... View more

It�??s this option. -stdlib=libc++ Change to -stdlib=libstdc++ and it should work fine. ... View more

Currently the only way to do this is: EnumRows m_AllRows; .. .. int numOfRows=0; while(m_AllRows->Next(NewRow)==S_OK) { numOfRows++; } In the next release you will be able to use SELECT COUNT(*) FROM Table to return the number of rows. We expect to have the next release available before the 2014 Dev Summit. Possibly earlier. ... View more

Is the DYLD_LIBRARY_PATH set to the location where the libraries are? If so, can you provide the link line and options used when linking. ... View more

What versions of the API and ArcGIS are you using? Can you post your code? ... View more

File Geodatabase SQL is based mostly on the SQL92 standard which does not include FROM in an a UPDATE. Normally this sort of update would be performed using a subquery. The 1.0-1.3 versions of the API are based on File Geodatabase as it existed at 10.0. This did not include support for aliasing. So "SET Field1=a.Field2 FROM Table2 a , Table1 b where a.OID=b.OID" would return an error in any case. The next release which is expected later in 2013 will be updated to 10.2 File Geodatabase SQL. File Geodatabase support for subqueries is limited, so I can not promise that it would work in this case. I'll take a look and report my findings. ... View more

What is the source of the shapefiles? Where they created with ArcGIS or ?  Failed how? What error was returned? Was this working before you added data creator and editor fields? Any details would be helpful. ... View more