MI Unrecognised Command "Server Execute"

1999-08-05 Thread IDS
Hello, I am trying to execute the "server-execute command" in a loop. The syntax that I have written is as follows: hdbc = Server_Connect("QELIB","DRIVER={MapInfo Win32 Oracle8 Driver3.10};UID=PO8;PWD=PO8;SRVR=") str1 ="Server_Execute("+hdbc+", "+"""INSERT INTO TEMP_CLASS(ron,retlr_id)select row

RE: MI saving workspaces

1999-08-05 Thread Andrew Waltho
Natalie, What I do is manually edit the paths in the workspace file to make them relative rather than absolute (ie .\data rather than c:\data). This means that the files can be either run directly from the CD, or placed in any other part of the directory structure on another machine, under a dir

MI Joining two columns - thankyou

1999-08-05 Thread Alistair Hart
Thanks to all those who took the time to reply to my problem. All those replies gives a bloke warm fuzzies about MapInfo (not all that common). I used update columns & it worked a treat. Regards, Alistair Hart Dengue Action Response Team Tropical Public Health Unit Cairns Australia [EMAIL PRO

FW: MI saving workspaces

1999-08-05 Thread Jones, Mal (DEM, PH)
-Original Message- From: Jones, Mal (DEM, PH) Sent: Friday, 6 August 1999 8:48 To: 'Swayze, Natalie: WPG' Subject: RE: MI saving workspaces Good morning Natalie, I have saved workspaces to a CD and had them work properly. This is how I did it: Save all the MI data into one directory

RE: MI saving workspaces

1999-08-05 Thread p . graham . mky
Natalie It is possible providing you follow these rules: 1. place all your tables and workspaces in one folder on the CD after editing out any drive:\folder prefix in the workspaces. There may be a way to use UNC's instead of drive:\folder to locate your tables if you wish to retain the folder s

Re: MI Y axis values on graph

1999-08-05 Thread Neil Havermale
Your issues of scale are in the way. If your intent is to show correlation then simply normalize both data sets around mean=100 and your should be able to illustrate. MidNight Mapper aka Neil Peter Walsh wrote: > I am trying to graph 2 variables in MI on the same graph. That is quite > possibl

Re: MI saving workspaces

1999-08-05 Thread Mats Elfström
John Musolino wrote: > >Can the problem be adjusted by opening the .wor file in a text > >viewer and changing the directories that MI searches for the tables? > The last choice is probably your best bet. From time to time I have to take > workspace files from my PC to another in the departme

Re: MI Workspaces

1999-08-05 Thread Mats Elfström
Roger Ling wrote: > However MI Proviewer only accepts MI 5.0 workspaces or before, which > is a problem given that we now have MI 5.5. Hi All! And Proviewer does not accept tabfiles that are indexed in other language versions of MapInfo which makes ProViewer virtually useless for us in other coun

MI Creating Points Problem in 5.5

1999-08-05 Thread kkobylski
Hello List I know I have posted this problem before, but when I looked back on the Mapinfo-L Archives the responses to my question were deleted. So I will ask again, I am trying to create points from a two tables I created in Excel and geocoded using MapMarker. The files geocoded correctly but whe

Re: MI Polygon Compactness

1999-08-05 Thread Bill Thoen
I had to build one into a project I did a couple of years ago, and it calculated "compactness" by two methods (and there are more in the literature, but these were what the State of Colorado's legislators required): 1. Reock test - Ratio of the district area to the area of its minimum bounding ci

RE: MI regions are lines in thematic map?

1999-08-05 Thread Talbot, Gary W
Put this thematic template into the template folder. You have to create your own and then save as a template, I do not like the default either. <> From Gary W. Talbott email: [EMAIL PROTECTED] phone: 562-491-2817 PAX: 32817 Visit our website and check out what we can do for you. http://edna.

Re:MI: Universal Translator causes crash

1999-08-05 Thread TechSupport
You are likely running Vertical Mapper at the same time as trying to set a projection via the UT, and the dialog disappears. This is a Northwood Geoscience bug with Vert. mapper. Read on for details. If Vertical Mapper version 2.1 from Northwood Geoscience was recently upgraded or downloaded

Re: MI saving workspaces

1999-08-05 Thread John Wall and Associates
> It shouldn't matter, as long as the .wor and all associated tab files are in the > same directory on the CD. In a typical .wor file, you will see the line: > > Open Table "C:\PROGRAM FILES\MAPINFO\PROFESSIONAL\DATA\Widget101" As Widget101 > > Simply edit it to read: > > Open Table "Widget101" A

RE: MI saving workspaces

1999-08-05 Thread Bedarf, Derek
I know there is a way to set an environment variable in the system properties in NT (and it can be done in 95 & 98 too). Is there a way to use that variable for workspaces? If so, the user would just have to specify the variable on their machine and the workspace would work. A slight pain, but

RE: MI MB: Universal Translator from MapBasic

1999-08-05 Thread Matt.Wilkie
>I asked this question of MapInfo Tech Support a couple of >months ago regarding v5.0. They told me it was not possible to >control the UT or ArcLink through Mapbasic. > >If anyone knows of any way to run these tools other than >"manually", I would very much like to know also. me too please.

Re: MI saving workspaces

1999-08-05 Thread John Musolino
I wrote: >The last choice is probably your best bet. From time to time I have to take >workspace files from my PC to another in the department which is hooked to the >big plotter (yes, it should be networked, but that's another story...) I save >all the files to disk (you would save them t

MI Polygon Compactness

1999-08-05 Thread Chad
Dear List, I have been searching for a MB utility that would determine the compactness of an irregularly shaped polygon. I checked the list archives and found a couple of references to compactness, but I could not find any information about a "compactness utility." My questions is simple, does

MI labelling join queries

1999-08-05 Thread Chris Halchuk
Dear listers, Another label question - my apologies if this has been covered lately. I have two tables, one of which called STATION contains graphic point locations and attribute data. The second table, SUBSTAT contains strictly non-spatial attribute data but can be joined back to the STATION t

MI MapXtreme Java

1999-08-05 Thread Antoine Gilbert
Hi   I don't know if there are many people here who use MapJ   We experienced many problems with this product...   I need to modify the features of a layer, it seem to be not possible in MapJ to do that, i have to remove the features and recreate them for have a modification. And the functio

MI What is cylindrical projection for mapping?

1999-08-05 Thread Alice Dobry
Hello all, I made a few maps for my client using MI's default lat/lon projection. However, I'm finding out now that point data isn't overlaying correctly, and it's probably due to some projection problem. Someone mentioned that the other plots that I need to create maps to go with was done usin

Re: MI saving workspaces

1999-08-05 Thread Steve Wallace
At 10:54 AM 08/05/1999 -0400, John Musolino wrote: >The last choice is probably your best bet. From time to time I have to take >workspace files from my PC to another in the department which is hooked to the >big plotter (yes, it should be networked, but that's another story...) I save >all the

RE: MI: Universal Translator causes crash

1999-08-05 Thread STAUB Paul
I agree, the UT is really not crashing, but merely not readily visible. I use the old Windows technique of alt-tab to cycle through what applications are open. The UT always comes up this way. Paul Staub Oregon Dept. of Geology Rick >From my experience this is not a "crash" but more a p

MI Re: Iif() function proposal?

1999-08-05 Thread Bill Thoen
What you want is called an immediate if function, and yes, it's VERY handy. The syntax is: Result = iif(, , ) The way it works is that if ConditionExpression is true, return the result of ExpressionTrue, otherwise return the result of ExpressionFalse. You can even nest iif() expressions within i

MI Imagine Files

1999-08-05 Thread Melissa C. Aldrich
Hi List, Has anyone successfully used Imagine files in MapInfo compositions? The extension is .img and is our organization's standard. They are compatible with ArcView but MapInfo does not directly support these. Any data translators out there to remedy this problem? Cheers, Melissa C. Aldric

RE: MI MapBasic LabelInfo() question

1999-08-05 Thread Sorak Lillian (ism1lxs)
Sorry for the late response, but hopefully this will help someone who has the same question. Try ObjectInfo(LabelInfo(iMap, ILayer, LABEL_INFO_OBJECT), OBJ_INFO_PEN). > From: CABRIEL Francois <[EMAIL PROTECTED]> on 06/08/98 > 05:02 PM GMT > Recipients: "'[EMAIL PROTECTED]'"<[EMAIL PROTECTED

MI RE: MapBasic Syntax Question

1999-08-05 Thread Neat, Richard (RLN)
Sorry, I just got my computer back on-line, and haven't had time to look at your code. However, it sounds like what you need to do is compare the centroids of the regions, and skip those that are within x miles of each other. Dick -Original Message- From: McNeil, Todd (TMCNEIL) Sent: We

Re: MI saving workspaces

1999-08-05 Thread John Musolino
>Does anyone know whether or not it is possible to save workspaces >onto a cd, so that they can be reopened from a different pc >( i.e. one that does not have the original .tab files in the >directory which they were made in)? >Can this be avoided by saving the individual files to the cd f

Re: MI International Licence!!

1999-08-05 Thread RichardDuncan
I don't know how these guys manage to put this stuff on the MI-List, but in case anyone might be interested in the come-along, I pulled this from a WA DMV FAQlist: "Is an international driver's license valid in Washington? Unless you are visiting fro

Re: MI MB: Universal Translator from MapBasic

1999-08-05 Thread Gary Searles
I asked this question of MapInfo Tech Support a couple of months ago regarding v5.0. They told me it was not possible to control the UT or ArcLink through Mapbasic. If anyone knows of any way to run these tools other than "manually", I would very much like to know also. thanx gary -

MI "auto layer builder"?

1999-08-05 Thread Swayze, Natalie: WPG
Is there a Mapbasic program that would load all available layers for the view I am looking at. Example if I zoomed into a 20 mile zone on a map, I would like to hit a button and have all the layers I have show up. A sort of AUTO-LAYER-BUILDER ---

MI saving workspaces

1999-08-05 Thread Swayze, Natalie: WPG
Hello all, Does anyone know whether or not it is possible to save workspaces onto a cd, so that they can be reopened from a different pc( i.e. one that does not have the original .tab files in the directory which they were made in)? I have a series of map layers( 8 .tab files), which I've create

Re: Combing tables with MI

1999-08-05 Thread maccomb
A simple way to combine tables is through the "append rows" function.  You can use this to append any two tables of identical structure.  This procedure would need to be repeated for each successive table to add and can therefore be somewhat time consuming. Table projection settings can be change

Re: MI Re: Jumping to a Specific View

1999-08-05 Thread Bob Young
Hi Jonathon This is easy to do, but I think its worth pointing out that MBR for objects ( which you need ) and MBRs for MAPS and tables are for fundamentally different purposes. You attached a message from Matt that referred to the MAP MBR. These are only there to increase tha accuracy MapInfo c

Re: MI RE: If statements in label expressions

1999-08-05 Thread Bob Young
Dear Sue and Roy I didn't see the orginal question, but wonder if the following is yet another approach. Run an SQL that selects all objects where value = "S" into tabS. Select all where value="T" into tabT. In layer control remove your original layer but add in both queries, tabS and tabT. Now

MI Utility

1999-08-05 Thread Franck Martin
http://www.sopac.org.fj/Presentations/GIS/Map/MapBasic/default.htm Contains a neat utility for Mapinfo. It draws Maps in 5mn and not posters in 1hour. Please send feedback on the Version 1.40Beta Cheers. -- To unsubscribe

Re: MI batch table editing

1999-08-05 Thread Bob Young
Dear Matt I can confirm that I have seen both of your messages. However a good reply is not so easy! If I was going to do this I think I would develop a program to read the table of styles ( embedded inside each MAP file ) and edit these direct. I would then have a program that allowed me to sel

RE: MI Workspaces

1999-08-05 Thread Robert Crossley
Is there a way that you can switch this automatic printer setting off? It is a pain when you want to print for example a draft set of maps, then a final and maybe one set to images. You used to be able to just change your print settings for a whole run, and reprint. Now it resets the printer ea

MI Re: Jumping to a Specific View

1999-08-05 Thread Jonathan Stokes
ahoy listers a MapBasic question here (and i imagine it will be dead simple). i have a number of MI tables that make up a map of the UK when opened togther in the same mapper window. one of the tables contains a series of regions within the UK (there are quite a lot of them - approx 180. we've wrt

Vedr: MI Mapinfo 2 DGN

1999-08-05 Thread pel
Hi Denis The UT is a light version of FME from Safe Software and it works the same way. This mean that you can run it from the commandline, from a batch file or from a MapBasic program. The command is C:\mapinfo\ut\imut.exe mappingfile [- keyword Value] [- -macroname value] the key in control

Re MI 5.5 New Charting Annoyances

1999-08-05 Thread magnorth
To Peter Walsh & other MI 5.5 Users A very annoying feature that has struck me is that once you've created the chart and placed it in the layout the legend attached to the chart continually resizes and displaces itself to a different position. You constantly have to change it in the graph window