RE: MI-L selecting blank records?

Hi Brian, The best query will be Select * from where not this is valid for all column types otherwise for specific col type you can use Select * from where ="" (for text) Select * from where = 0 (for integer) and so on.. regards, Anirban -Original Message- From: [EMAIL PROTE

Re: MI-L querying numbers to right of decimal place

Jacques Paris has provided an example in case your column is a string. If it is a number, then try: where int((column-int(column))*100)>0 Kind regards Uffe Kousgaard www.routeware.dk - Original Message - From: "Gerasimtchouk, Renee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wed

RE: MI-L OS Mastermap - Oracle Spatial

David I know you can't use data stored in Oracle Spatial by ARC SDE in anything else - or rather, you can read it but ESRI make no guarantees about performance etc because they maintain their own indexing via SDE. Sharing 'live' would be a nightmare of rebuilding indexes (off triggers? has anyone

Re: MI-L OS Mastermap - Oracle Spatial

ArcSDE can be setup to store data in Oracle in either the native Spatial format or in ArcSDE's own (and older) relational model. Since Spatial is only available with the Enterprise level of Oracle, this choice makes sense. Oracle Spatial actually also has a native mode of storing spatial data simi

MI-L Refresh Thematic map

Hello all, here i am again begging for your knowledge :-) I have a workspace with a thematic map in a linked table. Sometimes, when I refresh the table, new classes appear and all those objects go to a new class called "all others". There are any way to "refresh" the Thematic map and assign n

Re: MI-L OS Mastermap - Oracle Spatial

As far as I now, Oracle Spatial in in the Standard Edition or Oracle 9i. With 8, it was only available with the enterprise ($$) one. I am using Oracle Spatial and it works ok. However, the Mapinfo Access to Oracle Spatial is rather poor in some cases. Regrads Christof --

MI-L Table included in 2 Wor's

Hello all, let's see if I can get an answer from you. I don't know if my questions are too basic or too dense but I rarely get an answer. Let's try again... I have 2 workspaces with some tables in common. When I open the 2nd, I get a message "(...) A table named... is already open, Choose a

MI-L GPS Vehicle Tracking

Hi all, Thanks to everyone who responded to yesterday's GPS units question! A new request has just popped up: Does antone have any experience with GPS Vehicle Tracking? Ideally what I'm after is a system that will provide me with 20 vehicle units and a base station that will allow real-time vehi

MI-L Regions styles in the legend

Besides positioning an irregular shaped polygon in the layout, is there any way to change the shape of the boring rectangle MapInfo uses in the legend to display region styles? __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health

MI-L Multiple File Select in Custom Dialog

Hello, Does any one know how to select multiple files using the "DlgFileOpen" command in mapbasic. I would like the user to click a button and be presented with the file open dialog then be able to select multiple tables. Any suggestions as to how to go about this would be great. Cheers Geoff

Re: MI-L Multiple File Select in Custom Dialog

Hello XBODLG, Thursday, August 01, 2002, 5:09:36 AM, you wrote: Xecu> Hello, Does any one know how to select multiple files using the "DlgFileOpen" Xecu> command in mapbasic. I would like the user to click a button and be presented Xecu> with the file open dialog then be able to select multipl

Re: MI-L Multiple File Select in Custom Dialog

Do you only to see which tables were selected, or do you need them to be opened ? You could use the build in Open Table dialog, and afterwards capture the names of the tables that were opended using this dialog: 1. How many tables are open now 2. Run Menu Command M_FILE_OPEN 3. Now detect if the

MI-L Table included in 2 Wor's

Hi Luis, The problem should have been fixed by now. But you have to save your workspace with the latest version of MapInfo, because the fix is made in the workspace save, not in the workspace load ! You could also make sure that every line in your workspace that begins with "Open Table ..." ends

RE: MI-L Table included in 2 Wor's

Hi All lines ended with Interactive. The problem was in using a mapped drive. I replaced the path for the full path and now it works. Never use mapped drives in the path :) Thank you! Luis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 1 de A

MI-L RE: Cross Threads (was " MI-L MapInfo Scale")

Roy, this is an example of a "cross thread". I suspect you used an old email and wanted Anibrian to reply to your question about mif's. However the subject still relates to scale. If you pull up an old email to use as a reply besure it either only goes to the individual, or if it goes to the li

MI-L FoxPro and VB

Hi List, Silly question and only partially related to MapInfo, it's one of those non-mapinfo questions that arises out of using mapinfo and vb... Anyone know how to search a foxpro dbase in vb using the recordset object? I have used it on access with no hassles, but I keep getting an invalid ind

Re: MI-L MapBasic DEF

FYI, In MapInfo Pro 7.0 the MapBasic.def contents are included in the MapBasic Reference Manual PDF file in Appendix C. Should make creating expressions a little bit easier now. Regards, -Bill Mail List: [EMAIL PROTECTED]

MI-L Multiple raster images in same map troubles

I have 2 sets of aerial photos for the same area. Set A's project is UTM zone 15. Set B's projection is State Plane. I thought with the new Mapinfo 7 features of the transparent layers I would be able to overlay these 2 images, but Mapinfo does not reproject the images correctly. It shifts the

MI-L ShellExecute

Andrew Canfield’s message about using ShellExecute as a way to launch some external procedures from MapBasic caught my eye and the details of the function made me realize all that can be done with it. I have documented it for MB in a new page on my site. You could find it via www.paris-pc-gis.com/

MI-L Problem with fill pattern scale

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear all, I am trying to produce a map with different fill patterns and colored backgrounds. It looks nice in the screen, but ...when printing, the pattern turns to be so small that the whole region becomes black (or the pattern color) instead of

MI-L AMG coordinate Conversion

Hi all, I am trying to display the coordinates of the mouse pointer in an application (not MapInfo). The map data is currently in AMG a Universal Transverse Mercator projection), and the sidplay is quite easy using trigonometry. Unfortunately the users don't know about AMG coordinates so wan

MI-L Calculate Compass Heading

helloo, ONLY READ FURTHER IF YOU ARE ALREADY BORED, I TAKE NO RESPONSIBILITY FOR INDUCED SOMNAMBULISM. can anyone tell me how stupid i am? this isn't a necessary function of my program, just a nice add-on, but can anyone tell me if my calculations are correct or not. given a start X / Y and

MI-L Buffer problems

aloha, i use a buffer around my polylines to select nearby points on another table. the buffers i use however are somwhat smaller than a lot of the examples i've come across where they are calculating stuff on a statewide basis. my buffers are around a Bus Route drawn as a polyline, to pick up

MI-L MB - Select with object variables

Hi all, I'm after some ideas. I have about 40 tables of bus routes open in a single mapper window, some are within view, some are not. Out of the 40 layers I need to determine which ones are actually visible in the current mapper. Any ideas greatly appreciated. MY ATTEMPT: I was

RE: MI-L Calculate Compass Heading

thanks, it seems to have pretty much the same formulas as i used, a couple differences. but in the end my function is going to be within Access/VB so that it can calculate the bearing without MapInfo. my problem there is that VB doesn't have native derived math functions, and i'm not smart enoug

Re: MI-L Calculate Compass Heading

From: "Simmonds, Ashley (PTB)" <[EMAIL PROTECTED]> > helloo, > > given a start X / Y and an end X / Y i want to calculate a bearing. please > bear with me, i am in the southern hemisphere so this may be backwards for > many of you. Read here: http://williams.best.vwh.net/avform.htm The informati

MI-L Again on MapInfo Scale

Dear listers, sorry to drop in again with the same request. actually i did'nt get any reply form anyone. May be my question is too easy for you all. but please give me some info on this. My last mail - see below Dear Listers, This may be a very simple question but to me it is not clear. How i

Re: MI-L MB - Select with object variables

> '*** The following bit must be wrong because > '*** it never evaluates to true. > > If s_Layer intersects o_Rectangle then > LayerIsVisible = TRUE > end if It is amazing if this compiles at all. You will either have to use function IntersectNodes() and loop through all records in s_Layer or sa

RE: MI-L MB - Select with object variables

Hi Peter, Here is my version of your IsLayerVisible() * Function LayerIsVisible(ByVal WinID as integer, ByVal s_Layer as string) as logical Dim Mx1, Mx2, My1, My2 as float, o_Rectangle as object LayerIsVi

MI-L Coordinate Problem

Dear Listers, I am having the following problem. I have some location map in Smallworld. if you take any point on the map say a location the non earth coordinates (default in Smallworld) is x=4314567678mm the Lat long is 77.13 E and 13.21 N (India polyconic) Now i am importing some locations

RE: MI-L MB - Select with object variables

Never mind, I worked it out. This function checks if any objects from a specified layer are visible in the current map window - (nothing to do with layer on/off) Function LayerIsVisible( ByVal WinID as integer, ByVal s_Layer as string ) as logical Dim Mx1, Mx2,

RE: MI-L MB - Select with object variables

Thanks, I will incorporate your suggestion of creating the rectangle object variable outside the function - might speed things up a tad. Cheers, Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 August 2002 4:22 PM To: [EMAIL PROTECTED] Cc: [EMA

Re: MI-L Again on MapInfo Scale

Hi Anirban, usually we use real (not paper) units in GIS. For GIS scale is accuracy and detailness - not the size. If we have a raster 1:1 from a 50cm*50cm paper map we create a digital map with 5km*5km size. Then we can print this map in 1:1 scale or in any other scale, but we won't have

AW: MI-L Again on MapInfo Scale

> 1. How to identify the Scale of a Map (not the display scale but the > scale > in which the map is created) from my understanding, there is no such thing as a creation scale of a map in MI. you draw your things (in the projection you have choosen) and that's all. the scale is only needed for d

Re: MI-L Coordinate Problem

Can you import MapInfo map "as is" into Smallworld without converting it to NonEarth map? The problem again is in scale/coordinate system/projection. Lena > Dear Listers, > > I am having the following problem. > > I have some location map in Smallworld. > if you take any point on the map say a l