MI Changing the Cursor for adding nodes

it is run. Have I overlooked something simple? Has anyone managed to change the drawing cursor to something other than the crosshair? Any help would be appreciated. Regards Martin ====== Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Wait

RE: MI Tiny SQL-problem!

select * from mytable where a = "" or b = "" or c = "" Cheers Martin -Original Message- From: Christian Malmquist [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 8 August 2000 23:45 To: [EMAIL PROTECTED] Subject: MI Tiny SQL-problem! I need a sql-query that returns only the rows that

MI RE: high res image generator

with a common scale factor and common position - which in turn enables a PowerPoint presentation to be created that can appear to 'show' layers being turned on and off. Cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere

RE: MI Bug in Table Update Column?

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

RE: MI info tool doesn't like my files

Tim In the mapbasic window type set window info position(0,0) to get it back. Cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: Tim Warman [mailto

RE: MI creating points from centroids

(lat/Long) values regards Martin ====== Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: Mitchell, Will [mailto:[EMAIL PROTECTED]] Sent: Friday, 28 April 2000 09:02 To: '[EMAIL

RE: MI Speeding up mapbasic code

and reopen it. Hope this helps (don't forget to issue the command 'set table mytable fastedit on undo off' before doing the updates as this will definitely speed things up) Cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson

RE: MI Copying Boundary Lines.

with the existing polygons. (Either that or you get the dreaded "error overlaying objects" message which indicates that the original data isn't as clean as you thought) simply and stacks quicker than digitising all the little bits. Cheers Martin ====== Marti

RE: MI Creating a template layout

Hi Vinesh, This is straight forward. Simply create your layout as you want it including the map frame and then save it as a separate workspace. To get the date working open the workspace file in a text editor and find the string that you entered when you created it and replace it with the

RE: Text from Word to MI 5.5

Additional Text: For those that don't know you can actually get the layout to contain a block of text that is longer than you can manually enter in the text box. This is achieved by editing the workspace file directly. I haven't sat down to count but I think the test box lets you enter around

Sum: MI Folder Dialog

Thanks all those that replied. I implemented Eric Frost's solution which worked a charm. Thanks to everyone that replied and Eric if you are every down this way I owe you a beer. Cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private

MI Folder Dialog

way within MapBasic to give the user a graphical way to select a folder - the ability to create a folder at the same time would be helpful also but not essential - and I don't want to create my own dialog from scratch. Thanks in advance. Martin == Martin Roundill GIS

RE: MI Do we want to create a MapInfo Newsgroup?

I agree with Chris - plus I am in the same boat i.e. no work-based newsgroup access Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: PERRY Chris [mailto:[EMAIL

RE: MI Automatically Create Lines Between Points

== Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: Keith Campbell [mailto:[EMAIL PROTECTED]] Sent: Friday, 17 March 2000 22:55 To: [EMAIL PROTECTED] Subject: MI Automatically Create Lines

RE: MI PDF Conversion problem with TEXT

I have experienced similar problems in the past and found that non-rotated text disappeared but rotated test stayed (particularly with halo). The solution was to rotate the non-rotated text by 0.1 of a degree. Strange but true. Cheers Martin == Martin Roundill

RE: MI sub does not match declare

statement can use a different variable name if required eg Sub IsTableOpen(ByVal SomeOtherName_str as string) is also valid. Cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original

RE: MI help numbering items

Change the Expression to ROWID select Ok Print the table QED Regards Martin ====== Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: Main, Brian [mailto:[EMAIL

RE: MI odd/even query

row eg Xth row: select * from query1 where rowid mod X = 0 Cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: Erick Posner [mailto:[EMAIL PROTECTED]] Sent

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

and divide the original value by 100,000,000 ie shift the decimal 8 points to the left. eg update mytable set newcol = int(id_number/1) cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand

RE: MI Date: Tue, 22 Feb 2000 11:42:47 -0600

to either append these fields together (and query that new field as above) or alter the SQL to handle the multiple fields - I think this latter approach will cause problems with the embedded select statement. Hope this helps Martin == Martin Roundill GIS Manager

RE: MI PS / PDF output

I have had good success with using HP printer drivers (running MI 5.0 on NT4 I use HP2500cp driver). The files are saved as postscript and distiller 3.01 reads then no probs. I do admit that we only generate these to enable PDF files to be created for general use not for high end production -

FW: MI Desagregation Method

Knowing my luck the original email I sent will appear a few seconds after I send this. However as I haven't (yet) seem this come through I will send it again. Cheers/Apologies Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109

RE: MI Batch - Polygons to centroids

into To_Change update To_Change set obj=createpoint(centroidx(obj),centroidy(obj)) Cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: Jacques Paris [mailto:[EMAIL

RE: MI Geographic Operators

Hi Eric, try select * from File1 where not object intersects any (select object from File2) into MyTable Anyone know of a quicker way to do this in SQL ? Cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson

RE: MI Changing a region object's centroid coordinates

with the new object. If there is an easier way I would be keen to also know as the alter object geography clause does not appear to have any centroid options. Cheers Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City

RE: MI Duplicates in query

Hi Jennifer, Without seeing your code it is difficult to know what your problem is. I find I can get rid of the duplicates by adding the the 'any' clause to the sql code. This stops the object being selected more than once if it is in multiple regions. eg select * from store_locations

RE: MI re: A quick way to save a window as a *.jpg

have missed the mark altogether. regards Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: ISSA, OTHMAN [mailto:[EMAIL PROTECTED]] Sent: Thursday, 3 February 2000 1

MI JOB: GIS Operator, Senior GIS Operator - Waitakere City Council, New Zealand

== Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the me

RE: MI One vs. Many Objects

it is in the order of your calculations - I find that using the 'update column.' command into a temporary column (then querying the column) can be significantly quicker than moving through each record individually. Martin == Martin Roundill GIS Manager Waitakere City

RE: MI Id question thanks

me+") from "+tab_name into maxval i = maxval.col1 + 1 close table maxval GetNextId = i End Function I sometimes also include the a statement to index the column - just in case it has been removed. Cheers Martin ====== Martin Roundill G

RE: MI Strange Behavior

Steve Are there any duplicate records - ie do you get the same results when you use a statement like select * from table1 where object intersects any(select object from table2) Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109

RE: MI geocoding problem

ccuracy of the match at a later time. Cheers Martin ====== Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: Alex Chen [mailto:[EMAIL PROTECTED]] Sent: Friday, 21 January 2

RE: MI text to mif

of the day it is just a simple thing you are overlooking. Let me know if you are still stuck. Martin == Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -Original Message- From: Laith Wark [mailto:[EMAIL

RE: MI Multiple columns selection in SQL

David, The easiest way to do this is to construct a command string and run that. eg Dim exp as String dim cmd as string exp = "A, B, C" cmd = "Select "+exp+ "from test" run command cmd Hope this helps Martin ====== Martin Round

MI Mapbasic: Reproject Statement

) TIA Martin === Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand Ph +64 9 836 8000 ext 8344 Fax +64 9 836 8001 email [EMAIL PROTECTED

RE: MI housekeeping

isn't that what metadata is for? (not sure what you mean by "..when the preference file was redone...") Martin -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, 26 October 1999 14:30 To: [EMAIL PROTECTED] Subject: MI housekeeping you are

RE: MI I've lost my Universal Translater - (if I ever had it.)

Clifford Why not install it on another machine - copy all the files and subdirectories from the 'UT' directory to your machine and reset the tool manager to point to the 'mut.mbx' file. Then uninstall mapinfo from the temporary machine. Cheers Martin === Martin

RE: MI MapInfo to ArcView Conversion Experiences

yway. In summary UT is brillant but expect to spend a couple of days experimenting to get it right - it would also help if you had arcview on the same machine or network so that you can check the results. Best of luck Martin === Martin Roundill GIS Manager Waitakere City

RE: MI Celeron Processor

queries are released. Not also that this occurs on all machines not just Celeron. Cheers Martin === Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand Ph +64 9 836 8000 ext 8344 Fax +64 9 836 8001 email [EMAIL