Re: MI MapInfo ProViewer Problem

2000-03-05 Thread Ng, Stanley Wing Fai
In MapInfo, I always sort out version problem by using Window WordPad to open the *.tab file, change the "! ver" to older one, say 450 to 400 (if do not utilize the new functions or new maximum no. of records that new version can handle ) and then save it. Not sure if it works for your case but

RE: MI odd/even query

2000-03-05 Thread Martin Roundill
I know this has been answered but since no sum was given - for other peoples interest you could also use the MOD function even: select * from query1 where rowid mod 2 = 0 odd select * from query1 where rowid mod 2 = 1 I believe this approach to be better because it can be used to get every Xth

RE: MI Truncating a column to display only the first two numbers

2000-03-05 Thread Martin Roundill
Vinesh, If your column is a number field rather than a character field you can expand on Mike's idea by including the Str$() function. eg update mytable set newcol = left$(str$(id_number),2) Alternatively if you are sure the id_number is always 10 digits you can use the INT function and

MI getting min/max coordinates?

2000-03-05 Thread Ian Robertson
I am interested in characterizing central tendancies of the width (E-W) and height (N-S) of a large number of polygons in a MapInfo table. Is there any way to generate the minimun and maximum coordinates associated with a polygon? Thanks much for any help. Ian Robertson Ian

MI GIS Trainee Position Mosman Council NSW Australia

2000-03-05 Thread Steven Heapy
Hi Mosman Council is advertising a GIS trainee Position in the Sydney Morning Herald on Tuesday 7th March. GIS TRAINEE OFFICER Scholarship with Mosman Municipal Council Mosman Council wishes to provide a career opportunity for a person studying GIS at TAFE or University. You would apply your

MI 4.5

2000-03-05 Thread Peter McPherson
Greetings, It has been sometime since I have used MI4.5, but I do have a question about the Tools Manager. When I use the Add Tool function, the tool does not appear in the Tools drop down list. Even if I use the AutoLoad function, still it will not appear. Is anyone still using MI4.5? Is