I'm using Arc 10.1. I am creating a parcel inventory where I would like to have a photo of the property attached as an attribute and view-able with an HTML popup. I have a polygon feature class built in my geodatabase. I created a Photo Field with data type as raster. I can load a photo while in an edit session of ArcMap but when I chose save edits I get an SQL error that looks something like this:

"An invalid SQL statement was used [fras_blk_MyPropertyTable] An invalid SQL statement was used [SELECT * fras_blk_MyPropertyTable WHERE rasterband_id in()]"

Any thoughts?

  • What's your data source type is? – Darksanta Apr 23 '13 at 16:10
  • The photos I am trying to load are Jpegs – ACrain Apr 24 '13 at 13:48
  • hmm, I cannot reproduce it. What geodatabase type are you using? Local Geodatabase or ArcSDE? – Darksanta Apr 25 '13 at 2:17
  • Hi, I appreciate the help, I'll try to give you a little more background. - File geodatabase local - Geodatabase is setup to be managed - Polygon feature class was created from aniImported shapefile, once it was imported as a feature class I added the Photo field with data type raster - Some times when I first try to save edits it gives me a geometry error, then every time after that it gives my the SQL statement listed above – ACrain Apr 25 '13 at 11:53
  • 1
    Carlos - I haven't figured out how to fix this but I have away that works, maybe it will work for you. Create an attachment table for your feature class and load your photos to that. Link will walk you through. help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/… – ACrain Apr 29 '13 at 19:53

Okay, Problem solved, it was an ESRI Error, after talking with ESRI Support they said that installing service pack one should fix it and it did. They only had 4 records of this happening and they weren't quite sure what was causing it. But any how Service Pack 1 does the trick. – ACrain 1 min ago edit

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.