Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question
    
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
show 7 more comments

1 Answer

up vote 0 down vote accepted

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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