MI-L re: geographic join

2005-05-25 Thread Jacqui Middleton
Dear List Thank you to all those who replied to my plea - Thanks particularly to Peter who suggested that I look again at the 52 rows and try to work out what I have - he gave a fantastic list of checks which I will keep and refer to!! Such a stupid error on my part - I was grouping the rows i

MI-L ECW and Custom symbol conflict

2005-05-25 Thread Kim Greenham
Dear list, My Mapinfo session crashes each time I try to pan/zoom any ecw image after placing a custom symbol (either self made or a MI supplied one). Have tried ordinary symbols, no problem. Also no problem with custom symbols over a jpg or bmp image. Reloading MI did not help either. Does anyo

MI-L selecting different objects in the same column

2005-05-25 Thread Jacqui Middleton
Dear List Does anyone know an SQL command that would allow me to select an array of different codes within the same column. The codes are W, P, S, H, R, C, M, E, F. I realise I can select these individually and then append the tables but I was hoping there would be a quicker way. I have trie

RE: MI-L selecting different objects in the same column

2005-05-25 Thread Francisco Javier García
Jacqui, Try with this Select * from table where column in ("W", "P", "S", "H", "R", "C", "M", "E", "F") Javier García -Mensaje original- De: Jacqui Middleton [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 25 de mayo de 2005 16:43 Para: MapInfo-L Asunto: MI-L selecting different obj

MI-L Formatting Fields

2005-05-25 Thread Ronning, Christine
Hi everyone, This is probably pretty simple, but I need some help. I have just received a road network that has listed address ranges associated with it, that were originally formatted as decimal. The problem I have is that the numbers have thousand seperators in them which I don't want for geoc

MI-L Detecting Windows by String Variables

2005-05-25 Thread John Polasky
Greetings List: Is there a simple way to have MapBasic detect the existence of a custom named window (where the name has been stored in a string variable)? Thanks! John E. Polasky The Schwan Food Company - List hosting provi

MI-L Coordinating Access with MapInfo

2005-05-25 Thread Bill Thoen
I've got several large Access databases that I want to use in a MapInfo application, but I was wondering if I need to take any special steps to keep them coordinated. In this case there is no mappable data associated with the Access tables, and they are opened and modified in Access and also in

RE: MI-L Coordinating Access with MapInfo

2005-05-25 Thread Alan Gunn
I work with Access and MI opened at the same time, sharing Access db's with both. I don't make changes to the db's using Access, but I do with MI. The changes are reflected on the reports I have in Access based on those db's, but the db has to be saved after making changes in MI, and the report has

MI-L MBX for Scale Bar reminder

2005-05-25 Thread Philip . Lesnik
Group. I want to create an mbx to remind my other co-workers to put a scale bar in the layout. Here is my vision. Either the user does a Ctrl+P to Print or File->Print. A message box will pop up saying "Did you put a Scale Bar in the Layout?" The user then clicks the cancel button to disreg

Re: MI-L Coordinating Access with MapInfo

2005-05-25 Thread Steve King
Bill I've been using Mapinfo intercatively with Access on a project for mapping the geology of an open cut mine. Some things are much more easily entered in Mapinfo whilst other queries and data updates are better handled by Access. The Access data is also used by other mining software. I have

Re: MI-L Coordinating Access with MapInfo

2005-05-25 Thread Robert Crossley
Bill, perhaps you would be better to use an ODBC link to the access databases in your case, so that you can avoid issues with table packing etc. If you also link to your Access data from a forms/ report only Access database, you will separate your data from the applications completely, and