MI-L Oracle - Easy Loader problem

Hi, i want to load a table with arround 37.500 records to Oracle 8.1.7 database ( i have do it i lot of time with bigger tables ) but where i upload my table to Oracle EsayLoader fails. by the 32.509 record. i have divide the table 1.table includes 1-32.500 rows and the second 32.500-37.500 . an

MI-L Thematic Map - Bar Chart Bug ?

Hello, I have a question about strange behavior in my Thematic Map: Problem: I am drawing a thematic bar chart with a mapbasic program using the command Shade The data input comes from a table with 30 fields/columns. Most of them contains 0 (zero). When I draw a barchart based

MI-L How to change objects style permanently

Hello list, How to change the objects colour/style based on database permanently (not as thematic layer) through mapbasic commands? thanks in advance Shashibhushan

RE: MI-L How to change objects style permanently

Sashib First you must extract the object of interest into a variable before it can be altered. Fetch First from MyTable MyObj = MyTable.obj Alter Object MyObj Info OBJ_INFO_SYMBOL, symbol_style In this case you are modifying the symbol style of the first object contained in the Table MyTable by

MI-L Help with coordinate projection

Hi, I think I am having one of those mental block type moments! I have the following information from an ESRI Prj file:- PROJCS["World_Equidistant_Cylindrical", GEOGCS["GCS_WGS_1984", DATUM["D_WGS_1984", SPHEROID["WGS_1984",6378137.0,298.257223563]], PRIMEM["Greenwich",0.0], UNIT["

MI-L code and tools to change objects style permanently

Shashib Jerry's reply is correct, but (just in case) dont forget you need to issue an update command to force mapinfo to accept the changed object so as per jerry's code>>> Fetch First from MyTable MyObj = MyTable.obj Alter Object MyObj Info OBJ_INFO_SYMBOL, symbol_style <<< now issue

MI-L Different Symbols for different Facilities on a map

Hi, Listers I have a Foxpro database with a table of "Facilities". Facilities come under facility types, e.g. "St Peter's", "St George's", "Calvary" would come under facility type "Church". OK, there are many of these Facilities, each coming under a facility type. Each facility type may i

MI-L Excel charts in MapInfo

Hello all, Is it possible to import/open an Excel chart into MapInfo? I looked around a bit on the web and haven't found anything. I could just be dense and am missing something very basic. If I cannot import/open a chart directly is the only way to get a chart onto a layout to import

RE: MI-L Excel charts in MapInfo

Hi Jennifer, Just off the top of my head.Not sure if you can import the graph, but another option is to create a bitmap of the graph using screen capture and open it in MapInfo for display only. Pretty quick and dirty way to do it, but you wouldn't have to recreate the graph in MapInfo. I've

RE: MI-L Excel charts in MapInfo

Hi Jennifer, I have done this before and just did it through the File/Open and under Files of Type just specify Microsoft Excel...the you can specify the field names. Hope this helps. Wendy Wendy Connors, C.P.T. Planning/Development Technician Region of Queens Municipality Phone (902)354

MI-L SQL Querying

Dear All I am trying to select all records within a column that have the tenth character as either a 2 or a 3. All of the records within the column have 13 numbers. Is there any easy way to produce a query for the above? Regards Andrew Tracey Information Support Officer Corporate Information C

RE: MI-L SQL Querying

This is the query you need Mid$(Column_name,10, 1) = "2" Or Mid$(Column_name,10, 1) = "3" Syntax: Mid$( str, num1, num2 ) Returns a portion of the string str starting at character position num1 and extending for num2 characters. Hope it works Cheers Tim -Original Message- From: A

RE: MI-L SQL Querying

Andrew, Try something like: 'Select * from Untitled where Mid$(ID,10,1) = 2 or Mid$(ID,10,1) = 3 into Selection' For Chars 'Select * from Untitled where Mid$(Str$(ID),10,1) = "2" or Mid$(Str$(ID),10,1) = "3" into Selection' For Decimals Enjoy, Jerry Jerry O'Sullivan GIS Consu

SV: MI-L code and tools to change objects style permanently

Hi, There is an other option: Make your selection: Select * From YourTable Where Str$(obj)="Point" ' and some other stuff if you need it Into a Change the current symbol to a symbol of your own choice (Use the symbol picker) 'Update your table: (use th

MI-L Looping

Dear List- Is it possible to run any kind of simple looping through the MapBasic command window in MapInfo?? I thought I tried it successfully once before, but can't remember for sure. If it is possible, can someone please share the trick? Thanks! -John --

RE: MI-L Looping

check out the attached response I got several years ago when I asked the same question. We do this all the time and it's such a timesaver... . www.maponics.com -Original Message- From: John Polasky [mailto:[EMAIL

FW: MI-L Help with coordinate projection

Hi Lars, Thanks for your reply. I got this from Bill Wemple and it seemed to be what I wanted. However it does not seem to give the same view as that in ArcGIS! I will give your method a try as well Thanks for your help Regards Martin -Original Message- From: [EMAIL PROTECTED] [mai

MI-L Help with removing data

HI I need some help I have point data that almost runs parallel to one another, if you view the entire layer it looks like a route. (It is a route but it runs parallel). I want a single line of points and not double. One of the things I thought I could do is change the number of decimal points from

MI-L Labelling Difficulties

Hello, I am trying to label the streets of Sydney in a third party software that doesn't have any layer control features, I therefore need to create a set of labels stored in a separate .tab file, the problem is that Sydney is quite large and MapInfo's auto generate label functions make the label