Hi Jonathan , to overcome this case once you can use SQL select and update the QueryN sometimes works...
Regards... Ahmet DABANLI --- Jonathan Disher <[EMAIL PROTECTED]> wrote: > I have two tables, one of polygon boundaries, and > one of points. I'm > trying to update a column in the points table with a > value from the > surrounding polygons in the boundaries table. > > I go to Table | Update Column, select the > appropriate parameters, and > hit OK. I get an error box stating "Datatype > mismatch in expression." > If I tell it to add a new column, it adds "Cannot > add temporary column > <columnname>". > > Any ideas? This works with every other set of > boundaries/points I've > ever tried it on, just not this one for some stupid > reason. The columns > are the same length and datatype (char 5). > > -j > > -- > --Jonathan Disher > --Geodata Consultants, Inc. | > http://www.geodataconsult.com > --[e] [EMAIL PROTECTED] | [v] +1 800 838 > 6661 ext 11 > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | > www.directionsmag.com | > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
