RE: MI Bug in Table > Update Column?

2000-06-29 Thread Martin Roundill
I think this bug was also in v5.5 as I have come across it before - but didn't have time to look closer - in my case it was data in a 'linked' excel spreadsheet. Martin -Original Message- From: Karl Kliparchuk [mailto:[EMAIL PROTECTED]] Sent: Friday, 30 June 2000 12:22 To: [EMAIL PROTECT

MI: rotated ellipses and moving nodes of polygons

2000-06-29 Thread Markovic, Zoran
I am trying to find solutions for two MI problems: 1) drawing ellipses under an angle (that is, how to create rotated elliptical buffers). Apparently, MI can only create horizontal or vertical ellipses. 2) an algorithm/code for moving nodes of adjacent polygons (that is, I want to change the sh

RE: MI Automatic Line Drawing

2000-06-29 Thread PERRY Chris
Phil, Try "Connect the dots" which should be under the Tools section on the http://www.directionsmag.com site Cheers Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, 24 June 2000 6:52 To: Goodwin, Phil Cc: [EMAIL PROTECTED] Subject: Re: MI Auto

RE: MI dispersion

2000-06-29 Thread Jacques Gelinas
Antoine   This might not be the full solution your are looking for but it might be a work around.   With VM use the "region to grid function" and set the "grid cell size" to correspond to a pre selected thematic range value (this is the logical part). Once the grid is created within the regio

MI Bug in Table > Update Column?

2000-06-29 Thread Karl Kliparchuk
I was showing some clients this function of MapInfo Pro v6.0. I have a table with 4 polygons in it representing catchments. I also have a temporary table that I had created from an SQL Select. I used some of the data aggregation functions to produce some statistics on population per catchmen

MI Raster quality is poor

2000-06-29 Thread Gabor Vasarhelyi
Hi all, I am using BMP, TIF and JPG files as aerial backdrops to my maps. When I print these however using mapinfo the photo gets blotchy in a regular way. Very much inferior to the bit map being printed in another package such as the paint, corel or other. Why is it so? And what can I do to i

MI Layout Text and Frame Changes

2000-06-29 Thread Tim Rood
I'm trying to create a little MapBASIC script in the MB window that will fetch the next record of a mappable file, zoom to the coord of the currently selected record and then modifies a layout so that the currently selected map window, text labels (the window title is a text variable that co

RE: MI Labelling with concentration

2000-06-29 Thread Jennifer Duncan
Hi David, I can think of three and a half solutions for you which I think you'll like with varying degrees of happiness. First is to perform a SQL selection that will result in the aggregate column Count. Be sure to group them by the postcode and add a column count. This will result in a br

MI Volume in MapInfo?

2000-06-29 Thread Shapiro,Gerald W.
Hi. I am a new MapInfo user. We are using MapInfo to portray information about airspace characteristics, (flights/week, time in sector, etc). It appears to me that MapInfo is limited to two-dimensional display even the terrain mappers are just presenting the surface of the objects... a folde

MI Multiple Versions

2000-06-29 Thread Swayze . Natalie
Hello all, Does anyone know whether there would be any problems having both 4.52 and 5.5 installed on the same harddrive? Is there a WAY TO ENSURE SAVED USER SETUPS ARE THE SAME ON BOTH VERSIONS? application/ms-tnef

Re: Re: MI Change in Select Statement

2000-06-29 Thread Andrew_Dressel
Dima says: > Another SQL processor allows this. I have just made the query in Access: > > SELECT Count(sub_category_subscriber.sub_category_id) > AS CountOfsub_category_id > FROM sub_category_subscriber > GROUP BY sub_category_subscriber.subscriber_id; > > As you see, records are grouped by subs

Vedr: MI Carriage returns, extra!

2000-06-29 Thread pel
Hi David try this update in the mapbasic window (it has to be on one line). It will remove one carriage return evrye time you run it. Update Mytab set MyTxtColm = Left$(MyTxtColm, Instr(1, MyTxtColm, Chr$(10)) - 1 ) & Right$(MyTxtColm, len(MyTxtColm) - Instr(1, MyTxtColm, Chr$(10)) ) Peter

Re: MI MapInfo Fonts -- A Savage Journey into Pointless Pointsizes - REVISITED

2000-06-29 Thread Dany Bouchard
Bill, I already took a look at it ! This is quite something ! Holy cow it requires a lot to control text renrering ! I am not sure that I can see from your program how I can read existing MapInfo Text objects and get the size of rotated text with your WIN API functions. How would you do it ? Read

RE: MI Mapbasic - Reading if text object has carriage returns

2000-06-29 Thread pel
this is more ellegant, and it don't use the GoTo command Declare Function NumLine(byval s as string) as smallint Function NumLine(byval s as string) as smallint dim i, pos as smallint pos = Instr(1,s, chr$(10)) do until pos = 0 i = i + 1 pos = Instr(p

MI Refreshing Queries with ODBC tables

2000-06-29 Thread Jeff Hutzul
Hello Everyone,   I have a client who asked a question about MapInfo and ODBC tables.  He has a connected ODBC table that does queries with.  His problem is that when he changes something in the table, the numbers/objects in the query do not refresh.  The tables refresh but he wants the que

MI Carriage returns, extra!

2000-06-29 Thread David Eagle
I have a related question...Sorry to intrude Dany, I have a table full of data, one column of which is full of carriage returns, represented by a square symbol. Does anyone know how to delete them, either in MI or in Excel. They are more than an annoyance... Cheers, Dave On 29 Jun 00, at 10:2

Re: MI Radius Question

2000-06-29 Thread Bill Thoen
The answer depends on the form in which your data are assembled. I'll assume these are selections from the same table; the first, TWOMILE, is all the people within 2 miles of some location, and the second, FIVEMILE, is everyone within 5 miles of that location. In this case FIVEMILE also contains a

RE: MI Mapbasic - Reading if text object has carriage returns

2000-06-29 Thread Jacques Paris
That one was easy and I was already for it. Numlin returns the number of lines (carriage returns +1) in the a string Jacques Paris [EMAIL PROTECTED]  Paris PC Consult (mainly MapInfo app.) www.total.net/~rparis/gisproducts.htm declare function numlin(byval a as string) as smallint

Re: MI MapInfo Fonts -- A Savage Journey into Pointless Pointsizes - REVISITED

2000-06-29 Thread Dany Bouchard
This is a good idea ! I just try it but damn it, when I change the angle of the text using Alter Object Geography, I discovered that the MBR of the text does not change !   Stuck again.   Thanks again but we need to think more about this one !   Dany   - Original Message - From:

MI Labelling with concentration

2000-06-29 Thread David Eagle
Mappers, I have geocoded a number of responses to a survey by their postcodes (it would have been nice to use OS ADDRESSPOINT data but the addresses collected are too much of a mess to get any decent hit rate). As a result of this I now have in most cases one visible point on the map which ac

MI dispersion

2000-06-29 Thread Antoine Gilbert, KOREM
Does anybody know where i can find some code fragment (or algorithm) doing a logical dot dispersion in a polygon ?   ___   ||//Antoine Gilbert|| // [EMAIL PROTECTED]|| // #ICQ 9737371|| \\|| \\Le Groupe

Vedr: MI Mapbasic - Reading if text object has carriage returns

2000-06-29 Thread pel
Hi Dany Try using the Instr() function if instr(1,myString,Chr$(10)) > 0 then you have a Carriage return Peter Laulund National Survey and Cadastre, Denmark "Dany Bouchard" <[EMAIL PROTECTED]> - 2000 06 29 15:20:46 Til:[EMAIL PROTECTED] cc: (bcc: Peter Laulund/MI/KMS) Vedrørend

MI Mapbasic - Reading if text object has carriage returns

2000-06-29 Thread Dany Bouchard
This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC()

MI MapInfo Fonts -- A Savage Journey into Pointless Pointsizes - REVISITED

2000-06-29 Thread Dany Bouchard
Hello all.   I am (too !) trying to read the size of text objects in a MapInfo mapper window with difficulties.   Following Bill Thoen's approach here's what I am doing: First I callObjectGeography () to retrieve the minimum boundingrectangle (MBR) of the text object. I then take the vertica

MI unsubscribe

2000-06-29 Thread Tom Carter
Title: unsubscribe unsubscribe

RE: MI Radius Question

2000-06-29 Thread Will
Hi Erin, You can make your 5 mile circle into a donut and use that ring to select the set of points you need. Make the table with the 5mi circle editable, then select that object and do Object>Set Target. Then select the 2 mile circle and do Object>Erase. Now you have the 2-5 mile donut you

MI INCREASE BUSINESS SALES!

2000-06-29 Thread namesoncd5u
HELLO: THIS IS AN ADVERTISEMENT FOR 50 MILLION E-MAIL ADDRESSES ON CD-ROM. IF YOU HAVE NO INTEREST IN THIS INFORMATION, PLEASE CLICK DELETE. THANK YOU. Dear Consumer, Increase your business sales! How?? By targeting millions of buyers via e-mail !! We are offering over

MI Simple Query solved.

2000-06-29 Thread MJSully
Thanks to Jose Luis, Russell, Keith, Ahmet and Jo for solving my simple problem. Simply 1. Make sure you have a column to store the information. You may need to add a column (using table maintenance) on the Coded Table to do this, make sure it has enough characters to hold the descriptions y

RE: MI Routing Application Servers?

2000-06-29 Thread Kirsten Burrows
Dear John, You may be interested to know of a reference site using RouteXNetServer. Access www.madaboutbikes.com then go to "toolbox" to register your details, continue and click on "TravelMate" then "next". This is a UK based site so only UK routes apply. I'll keep you posted of any further refer

RE: MI Nearest Neighbor Analysis

2000-06-29 Thread Flavio Hendry
Hi Chiu If you're looking for Voronoi ... here some feedback: we compared TRIANGULATOR as suggested by Roeland van der Spek and VM as suggested by James Harvie on a dataset with over 200'000 points with the result that to my surprise TRIANGULATOR did the job perfectly and incredibly fast and V