[MI-L] update sql server column

I'm trying to write a mapbasic app that will update a table in a SQL server 2000 database from a .tab polygon table where the polygon table contains the table in SQL server (which has lat and long fields from which I can create points). Is this possible to do? I've connected to the sql

Re: [MI-L] update sql server column

Council Hastings St, Private Bag 6010, Napier, New Zealand Phone +64-6-835-7579 Ext. 8115 Fax +64-6-834-4195 mailto:[EMAIL PROTECTED] http://www.napier.govt.nz From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]] On Behalf Of Robert DeRubeis Sent: Wednesday, 4 October 2006 9:43 a.m. To: mapinfo-l

[MI-L] Centering Thematic Legends

I recently updated MI Pro from 7.8 to 8.5 and noticed that when I create a thematic legend, everything is Left justified. Using v7.8, the title, subtitle and ranges would all come up centered. Somewhere in v8.0 or 8.5 (I assume) mapinfo changed this to be left justified. I'd like to have the

Re: [MI-L] [Spam] saving to pdf form

I use eDocPrinter PDF Pro to create pdf files. It works as a printer in windows so any windows application when you choose print, just change to the eDocPrinter, and it will it as a pdf. It's worked great for me, even with large layouts in MapInfo. The link to download is below.

[MI-L] csv export error

List, I'm trying to export a MapInfo table to a .csv format, but I'm getting the following error message: Unable to access string resource (3286). Can anyone tell me why this is occurring? I am running MapInfo Pro V 7.8 with the latest patches installed on Win XP. Thanks, Bob

[MI-L] sql select

List, I'm having a problem with a selection query. I have 2 tables both editable with a common column named ID. Table B is my deleted records which I want to find in table A to delete. When I run the following sql select statement- Select * from Table A, Table B where Table A.ID = Table

Re: [MI-L] sql select

Technician Strongbow Exploration Inc. Suite 800- 625 Howe St. Vancouver, BC V6C 2T6 (604)668-8370 www.strongbowexploration.com From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]] On Behalf Of Robert DeRubeis Sent: Thursday, April 13, 2006 9:22 AM To: mapinfo-l@lists.directionsmag.com Subject

[MI-L] landuse classification

List, Can anyone provide a way of telling me what particular landuse code (ie-commercial, residential, etc) a particular address is in? I have a list of over 1,000 addresses across the US that I would like to do this for. If anyone has done this or knows of anyone who could do this, please

[MI-L] printer

List, I just changed to a new printer (from HP 2500 to HP 2800). If I go and change a saved workspace in page setup to the new printer and do a search and replace on all the other windows-in this case replace HP 2500 with HP 2800 in notepad- the workspace takes about twice as long to open. Why

[MI-L] saving workspace in mapbasic

Hi list, I have a mapbasic program I wrote with 3 seperate push buttons. The first opens a dialog box to open a workspace. The second closes a list of the old streetpro bottom portion of the hwy shields for every state that is no longer used, but referenced in the saved workspace. The third

Re: [MI-L] voronoi polgon

]www.MapsByAir.com Robert DeRubeis [EMAIL PROTECTED] 01/12/06 9:32 AM I got the same results with only 26 points as with all 15,000 so I guess the number of points doesn't seem to matter. Something seems to be off a little in MI Pro as to how it creates the voronoi polygons. -Bob Peter Horsbøll Møller

Re: [MI-L] Labelling....

Mike, Label as expression, then use the following- Str$(Column Name in your table) This labels the numeric column as a string, removing any commas. -Bob Mike Mayer [EMAIL PROTECTED] on Friday, January 13, 2006 at 11:23 AM -0700 wrote: Hello List, Yet another labelling question. This may be

Re: [MI-L] voronoi polgon

Odensevej 95 DK-5260 Odense S. Denmark Tel+45 6311 4900 Direct +45 6311 4908 Mob+45 5156 1045 Fax+45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert DeRubeis Sent: Wednesday, January 11

Re: [MI-L] voronoi polgon

: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 4:41 PM To: mapinfo-l@lists.directionsmag.com Cc: Peter Horsbøll Møller Subject: Re: [MI-L] voronoi polgon I have used the Distance Calculator in MI Pro v7.8 and that gave the correct closest store location. But I'm

Re: [MI-L] voronoi polgon

]www.MapsByAir.com Robert DeRubeis [EMAIL PROTECTED] 01/12/06 9:32 AM I got the same results with only 26 points as with all 15,000 so I guess the number of points doesn't seem to matter. Something seems to be off a little in MI Pro as to how it creates the voronoi polygons. -Bob Peter Horsbøll Møller

[MI-L] voronoi polgon

List, I have 2 point tables, stores and customers. I would like to find all the customers that are the closest distance to a particular store so I can assign information from the store to those customers. I created a voronoi polygon from the store points, then did a select statement where

[MI-L] printer

List, I just changed to a new printer (from HP 2500 to HP 2800). If I go and change a saved workspace in page setup to the new printer and do a search and replace on all the other windows-in this case replace HP 2500 with HP 2800 in notepad- the workspace takes about twice as long to open. Why

[MI-L] new printer

List, We just got a new printer (HP 2800) to replace an old one that died (HP 2500). When I opened one workspace in notepad, I noticed it referenced the printer 7 times(see below), even though there is only one layout in the workspace. Is this a bug in MI Pro, that it keeps appending the

Re: [MI-L] new printer

, the workspace is probably referencing every open window, not just the layout. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert DeRubeis Sent: Wednesday, December 28, 2005 11:55 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] new printer List

MI-L hurricane katrina data

List- Does anyone know if there is any place to get flooding data for katrina to be used in MapInfo Pro? I'm trying to do some analysis by identifying the areas that have been effected. Thanks, -Bob

MI-L add columns to multiple tables

I'm trying to write an mbx that will take multiple point tables, with different names and from different sub-directories (C:\AKdata, C:\ALdata, C:\ARdata, etc), add the first 2 letters of the table name to a new column called state, then add lat, lon columns and update those columns accordingly.

MI-L custom labels

as masters for other workspaces. I for one would find this useful. Bill Holler MS GISP GIS Administrator Information Specialist Data Services Division Town of Wethersfield, CT (860) 271-2854 [EMAIL PROTECTED] -Original Message- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Wednesday

MI-L custom labels

List, I'm trying to find out how many MIPro users would be interested in a program we created. MIPro users already know the problems associated with having custom labels inside saved workspaces. When a table is updated or overwritten (rearranging the rowid), the label no longer corresponds to

MI-L demox error message

List, Does anyone know what a .demox file is? I have one associated with one of my MapInfo Tables that I can't figure out how or why it got there. If I delete it, when I start up MI Pro 7.8, I get the following error message- ParseError: An exception occurred! Type:RuntimeException, Message:The

MI-L email in mapbasic

List, I'm trying to send an email with a .txt attachment throught mapbasic. Does anyone know if this is possible or not? I'm using mapbasic v7.8 and the email software being used is called FirstClass. Any help is appreciated. Thanks, Bob

Re: MI-L points with same lat/lon

Message- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 6:47 PM To: [EMAIL PROTECTED] Subject: Re: MI-L points with same lat/lon Saving the count query and the last step was what I was missing and it worked fine. I thought it wouldn't take so many steps and having

Re: MI-L points with same lat/lon

; execute; === returns a table of all lats that are duplicated and the number of duplication likewise for the longs. Hope this helps. kir. -Original Message- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 3:03 PM To: [EMAIL PROTECTED] Subject: MI-L points

Re: MI-L points with same lat/lon

(origtab.lon=duplocs.lon) and (origtab.lat=duplocs.lat) Viola'! Hope this helps Spencer -Original Message- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 12:02 PM To: [EMAIL PROTECTED] Cc: Kir Luong; Peter Horsb¿ll M¿ller Subject: Re: MI-L points with same lat/lon

MI-L points with same lat/lon

List- Is there a way to select all records from one table where the values in 2 different columns are identical? I wanted to select all records where the lat of 1st record = lat of 2nd record AND lon of 1st record = lon of 2nd record. I'm trying to identify where and how many points are right on

MI-L Printing large size prints

List- I created a large layout window in MapInfo Pro and I'm having problems getting it to print correctly. The size I'm looking to print out is 6'x9' or 72x108. My plotter is limited to 36 so I set up the layout to print the job on 2 pages both 36x108. It did this with no problem and is

MI-L Printing large size prints

List- I created a large layout window in MapInfo Pro and I'm having problems getting it to print correctly. The size I'm looking to print out is 6'x9' or 72x108. My plotter is limited to 36 so I set up the layout to print the job on 2 pages both 36x108. It did this with no problem and is

MI-L Printing large size prints

List- I created a large layout window in MapInfo Pro and I'm having problems getting it to print correctly. The size I'm looking to print out is 6'x9' or 72x108. My plotter is limited to 36 so I set up the layout to print the job on 2 pages both 36x108. It did this with no problem and is

Re: MI-L Printing large size prints

at a time. 4. Try printing to four 36 x 54 sheets (one page at a time) just to see if everything comes out. Hope this helps. Spencer -Original Message- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 1:18 PM To: MapInfo Listers Subject: MI-L Printing

MI-L mapbasic code to select pts within regions

Hi all, I'm trying to create an mb to do the following- 1)select all points from one table that fall in a certain region in another table, then 2) save them to a new table with the name of the region it fell in. For example, if I had a point table (cities) and a region table (usa), select all

Re: MI-L mapbasic code to select pts within regions

, 5000 Odense C to Odensevej 95, 5260 Odense S. Please note our new telephone, direct and telefax numbers. -Original Message- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 7:39 PM To: MapInfo Listers Subject: MI-L mapbasic code to select pts within

MI-L map window information

Hi all, I have a bunch of saved workspaces with many map windows and layouts in each saved workspace. Is there a way to get the following information from the map window- Zoom, center X, center Y. And from the layout windows- Scale on paper 1 in = ?? for each of the different windows without

MI-L MapInfo Performance

We are looking at getting a new computer to run MapInfo Pro and would like any feedback as to different types of specs. I'm assuming the standard with cpu and hard drive space-the most we can afford the better, but is a 2.4 ghz more worth it than say a 1.8 ghz? Does MI Pro run faster/better on

Re: RE: MI-L Create line between points

The connect the dot programs were exactly what I was looking for. Thanks for everyone's help. -Bob Adam, Jason [EMAIL PROTECTED] writes: There's aother one called ConnectTheDots and I've attached 2 versions to this note. Hope that helps, Jason -Original Message- From: Robert DeRubeis

MI-L Create line between points

If I had a table of different points, is there a way to create a line between those points going from point 1 to point 2, then from point 2 to point 3, etc? I can set up the table so the starting point would be the first row and the ending point would be the last row if needed. I was looking

MI-L City Table List

Does anybody have or know where to get a complete U.S. city table list? What I am ideally looking for is a complete list of cities/towns with the following columns= City, State, County, Population (if possible), Lat, Lon. I have downloaded and used the city places file(s) from USGS, but I have

Re: MI-L Strange Problem with Layouts

It could be your layout setting. Look under layout-options and make sure show frame contents is not on Never. See if that's the problem. -Bob [EMAIL PROTECTED] writes: I am running Mapinfo 6.5 under NT and have 258 mb of ram. I have a strange problem with Layouts that seems to be related to

MI-L Mapinfo printing extra paper

Hi there, I have a problem when printing from a layout in mapinfo 6.0. I am using a HP650 plotter on win98. If I do a custom paper size and put in something less than 36 width (like 30x30) it will print out the map fine, but will also spit out extra paper, out to about 42. If I put the custom

Re: MI-L Mapinfo printing extra paper

Robert DeRubeis wrote: Hi there, I have a problem when printing from a layout in mapinfo 6.0. I am using a HP650 plotter on win98. If I do a custom paper size and put in something less than 36 width (like 30x30) it will print out the map fine, but will also spit out extra paper, out