MI-L SQL help

2004-10-22 Thread Wangberg, Willie (USBORAX)
Does someone know a sql statement that allows me to add an incremental number to a table? I have a list of 60 things and I want to number them starting from 1-60. Or is there another way to do this in MapInfo? Willie Wangberg Information Technology Rio Tinto Exploration 52 Glen Carran Circle

MI-L Node extraction

2004-06-17 Thread Wangberg, Willie (USBORAX)
Is there a way to extract the coordinates of all nodes on a given line/polygon? Willie Wangberg Information Tech Rio Tinto Exploration 52 Glen Carran Circle Sparks, NV 89431 P: (775) 358-9500 F: (775) 358-9529 email: [EMAIL PROTECTED]

MI-L Duplicate Records (kind of)

2004-06-10 Thread Wangberg, Willie (USBORAX)
I have an excel file that contains lat/long for cities. However, it may gave the same location multiple times with a slightly different spelling of the city name. Is there a way to query the file and based on a field(s) (say where the lat and long are all the same in multiple records) and keep

MI-L Coordinate Conversion

2004-05-17 Thread Wangberg, Willie (USBORAX)
Does anyone know of a MapBasic program or any program for that matter that will allow me to convert a list of coordinates at once? I am going from lat/long to UTM. I have found several websites that allow for a single coordinate, but not one that I can get to work for a batch process. I have

MI-L Internal Error: 31107

2004-05-10 Thread Wangberg, Willie (USBORAX)
Does anyone know why or how this error, Internal Error: 31107, happens? I have had it happen several times in the last week once while trying to print out a raster the other time trying to print out a vector (not at the same time and not together). Willie Wangberg Information Tech Rio Tinto

MI-L MapInfo features.

2003-12-12 Thread Wangberg, Willie (USBORAX)
I am looking to do some basic things in MapInfo 7.0 that I cannot figure out. I have had all my training in ESRI products and am finding MapInfo a little more difficult to figure out on certain things. First off, I am looking to make vector data in the same layer have different colors based