Dear Tom, your analysis was absolutely right. I modified the name of the field using cname, and it worked.
Thanks a lot! On Monday 10 March 2008 16:25:33 Tom Russo wrote: > I think the problem here is the field named "UPDATE" --- the GRASS SQL > driver cries when you try to use field names that are reserved words in > SQL. The same happens for fields named "DATE" or "TIME" that are commonly > used in shapefiles. I believe that UPDATE is a reserved word. > > You'll have to use the "cnames=" option of v.in.ogr to rename the columns > to get around that. > > Unfortunately, cnames requires that you give a name to *all* the columns up > to the one you want to change, and your "UPDATE" field is the last one. So > you'd have to use: > > cnames=cat,AREA,PERIMETER,SSI_,SSI_ID,CARTO_CODE,OVERLAP_CO,SITE_NAME,SITE_ >HA,NOTIFIED,COUNCIL,TYPE,MIDAS_NUM,whateveryouwanttocallUPDATEinstead Best Regards -- Corrado Topi Global Climate Change and Biodiversity Area 18,Department of Biology University of York, York, YO10 5YW, UK Phone: + 44 (0) 1904 328645, E-mail: [EMAIL PROTECTED] _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
