MI easy open tab as txt question
Hi,
What does one use to import a text field with double quotes inside a string
("") on a File-Table-Open so MIPro doesn't see it as the end of the string.
I want to preserve the qq s in the string field.
-John
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI SQL Select full jolin
How do users get around doing a full join on two tables in MI Professional's SQLSelect? Example: I want selection to include a full join on table1.ID1 and table2.ID2, even if ID1 and ID2 do not match? The way SQLSelect works it must be an inner, left, or right join, but no full join. TIA -John -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Polygon Attributes
Hello Sebastian: There is a way of using the MapBasic commands like ObjectInfo, which has such an argument, objectinfo(obj,OBJ_INFO_NPOLYGONS) to return the number of polys for a region. Use an update column statement with ObjectInfo(obj,21) for a column, let's call it nPolys: nPolys = objectinfo(obj,21) 21 is the value defined in the MapBasic.def, which returns OBJ_INFO_NPOLYGONS. If you have a copy of MB, you can get the values from the .def, and the syntax of commands like TableInfo, ObjectInfo, and ColumnInfo from the .hlp. These might be on MapInfo's site, as well. I am not sure if the .def or .hlp can be distributed to unlicensed users. HTH John Chioles Network Operations Metricom, http://www.metricom.com office: 281-873-3443 mobile: 281-433-9325 -Original Message- From: Sebastian Hudson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 7:28 AM To: [EMAIL PROTECTED] Subject: Re: MI Polygon Attributes Andy, Thanks for the reply. Hopefully this will clarify what I am after. When double clicking on a region object it brings up a list of attributes such as area. One of these is the number of polygons that make up the object in question. Is it possible to do a query in mapinfo on all the objects within a table that will show how many polygons make up each object? I have large number of such regions that need checking regularly and doing it manually is time consuming and prone to error as some may be missed out. Thanks Seb For more information on ADAS, visit our website at http://www.adas.co.uk. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Help with Canadian Provincial Abbreviations
According to my sources 1) Nunavut is correct 2) NU is the abbreviation -Original Message- From: Lindsay Giles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 25, 2000 12:13 PM To: 'Thompson, Dara L. (RyTull)'; 'MapInfo-L' Subject: RE: MI Help with Canadian Provincial Abbreviations Hello Dara- 1) The correct spelling for it is "Nunavut" 2) To the best of my knowledge, they are both NT - all addresses I have seen within Nunavut carry NT as their descriptor. I could be wrong but I have not seen any other code. Lindsay Giles Senior GIS Analyst AXYS Environmental Consulting Ltd Suite 600-555 4th Ave. SW Calgary, AB T2P 3E7 e-mail: [EMAIL PROTECTED] Main Office:403-269-5150 Direct Line:403-750-7671 Fax:403-269-5245 Visit our web site at http://www.axys.net -Original Message- From: Thompson, Dara L. (RyTull) [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 25, 2000 8:55 AM To: 'MapInfo-L' Subject:MI Help with Canadian Provincial Abbreviations Hello all. I hope someone can help me. I am adding a 2-character field to the "Cncty_3k" file to identify the Canadian Province (or Territory). As my source for the 2-digit code, I am using the "Province" column in the "Canada" table. I believe that both tables are the supplied with MapInfo. Here are the problems: 1). The "Cncty_3k" file says that the provincial name is "Nunvaut". The "Canada" file says that it is spelled "Nunavut". Which is correct? 2). The "Canada" file says that the abbreviation for Nunavut is "NT". That is the same abbreviation for the Northwest Territories. Can someone tell me what the abbreviation is for the Northwest Territories as well as the Nuvaut Territory? Thanks! -Dara Thompson -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Crystal Reports crashing
Anyone have their Crystal Reports persistently crashing on them (VMI6.0)? Any tips to stop this? userinfo.log: ... The Operating system is: Windows NT Target Directory is: e:\Program Files\MapInfo\Professional Installing 32 bit MapInfo - Workstation Install Type is: Upgrade. Setup Type is: Typical Selected components are: Program Files Online Help Utility Tools Seagate Crystal Reports Universal Translator ArcLink - Target Folder is:MapInfo -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI another alter obj question
My error was in the symbol name which was "MapInfoSymbols", should've been "MapInfo Symbols". You'd think that if the font specified was invalid an error would be generated at runtime. HTH /jc -----Original Message- From: John Chioles [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 1:10 PM To: '[EMAIL PROTECTED]' Subject: MI another alter obj question Thanks to all who offered help w/ my alter obj question. Here's another one, a bit more perplexing: If I use the MakeFontSymbol() to assign to a symbol variable, using variables in the arguement the color is changed, but the symbol and fontstyle are not being changed. I am writing the same variables into a message window, and can see they are changing values correctly when I compare them back to several attributes in the table (33,50,51,52) as well as the fontstyle (0,16). I am receiving no error on execution. The same result on a rum command w/ the same string arguement. I am using "MapInfoSymbols." I can manually (edit) change a symbol style within MI Professional, and I can run KGM tool MB_TOOLS.MBX as another check to see the changes are the same. Anyone experience the same, and can offer a workaround? /jc -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI another alter obj question
Thanks to all who offered help w/ my alter obj question. Here's another one, a bit more perplexing: If I use the MakeFontSymbol() to assign to a symbol variable, using variables in the arguement the color is changed, but the symbol and fontstyle are not being changed. I am writing the same variables into a message window, and can see they are changing values correctly when I compare them back to several attributes in the table (33,50,51,52) as well as the fontstyle (0,16). I am receiving no error on execution. The same result on a rum command w/ the same string arguement. I am using "MapInfoSymbols." I can manually (edit) change a symbol style within MI Professional, and I can run KGM tool MB_TOOLS.MBX as another check to see the changes are the same. Anyone experience the same, and can offer a workaround? /jc -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI alter obj symbol in loop
Hello: I am trying to alter a symbol style in a for loop. Here's the relevant MB: dim NewSymbol as symbol dim objSelection as object set table newTab fastedit on for i = 1 to TableInfo(newTab, TAB_INFO_NROWS) select * from newTab into selSingleRec where RowId = i ' 'multiple criteria to set the symbol style parameters ' NewSymbol = MakeFontSymbol(nShape,nColor,14,"MapInfoSymbols",nFontStyle,0) set style symbol NewSymbol NewSymbol = CurrentSymbol() objSelection = selSingleRec.obj alter object objSelection Info OBJ_INFO_SYMBOL, NewSymbol update selSingleRec set obj = objSelection where rowid = i commit table newTab next I drummed up some old messsages to the list, to use as examples but couldn't get them to work. Any help is appreciated. -John -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI style override suggestions
Is there any easy way anyone has implemented to know whether a layer's display is in override without going thru the multi-click layer_control/display/style_override ? There is no automatic way from a map window to know if a display is in override. In layer control dialog a user still has to click on display to know if it is a modified display. Perhaps this could be implemented as an addition column in the too small layer control dialog Perhaps the display_type (symbol, color, etc. ) could automatically be displayed in the layer control dialog (like some other desktop GIS) without going to each layer's display separately. This could be useful when opening a workspace others have created. Is there an MBX anyone has distributed that does this? Thanks. John Chioles Network Operations Metricom, http://www.metricom.com office: 281-873-3443 mobile: 281-433-9325 -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI VM Square Cell Agg. w/ a .GRC?
Hello VMers: I am a VM newbie. Is it possible to use the Square Cell Aggregation technique with a .GRC, and then save the square cells as regions in a .TAB? Or, must one start with a point file first? It seems like this should be fairly straight forward operation in VM. TIA John Chioles Metricom - a world without wires http://www.metricom.com <http://www.metricom.com/> 16801 Greenspoint Park Drive, Suite #150 Houston, TX 77060 281-873-3443 -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI MB sanity check: Insert/Alter Objs/Table
Martin, Thanks for the response. -John -Original Message- From: Martin Roundill [mailto:[EMAIL PROTECTED]] Inserts can (and usualy do) have both eg "insert into mytable (obj, col1,col2,col3) values (newobj,val1,val2,val3)" Alters are carried out with the update command and can include both (they also usually have a rowid statement for individual updates) eg "update mytable set obj = newobject, col1 = val1, col2 = val2, col3 = val3 where rowid = x" -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI MB sanity check: Insert/Alter Objs/Table
MBers: This is a sanity check: Please confirm that it is not possible to insert both objects and values into a table w/ a single statement. Likewise, with Alter one can either alter an Object or a Table both not both at the same time. -John -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Add record numbers?
Actually you don't need the For loop. Just the update:
include "mapbasic.def"
'...
dim i, num as integer
num = TableInfo("YOUR TABLE",Tab_info_nrows)
'assumes the table is open...
update YOUR TABLE set id=rowid
HTH
John Chioles
Metricom - a world without wires
http://www.metricom.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MB Q: str$(coords) vs. MIF conversion
Coordinates read from an object, stored in a float, and converted to string with the function str$() return only 3 decimal places (.000) versus saving the object as a table, and exporting it to a MIF, which returns precision to 6 places. Why is this, I would think a str$(fCoordX) would return the same value. Thanks. John Chioles Metricom - a world without wires http://www.metricom.com <http://www.metricom.com/> -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI MB in 5.5 processor slows down
In a process of looping and multiple selects with a MB application, the process starts to slow down considerably. Can anyone offer suggestions to avoid this? Even if all other applications are closed, and screen savers, and power management settings are turned of are closed this still occurs. Will periodic Commits to an open table, and re-opening help? I am running W98,500Mhz,384 RAM. Thanks. John Chioles http://www.metricom.com -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI IntersectNodes vs. Euclidean to find lines intersection
Wondering if anyone compared the IntersectNodes MB function to find the intersection of 2 lines versus programmatically using Euclidean math? John Chioles Metricom - a world without wires http://www.metricom.com <http://www.metricom.com/> -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Object oriented programming for Map Basic
MI Listers: I am curious how others feel about MapBasic not being supported in favor of a MapInfo/VBA language versus just using MapX? Will the economics drive the functionality? Can the same analogy be made for Avenue/VBA/MapObjects ? Your thoughts are welcome. -John Chioles > -Original Message- > From: Scott Elliott [SMTP:[EMAIL PROTECTED]] > Kim, > > We did a story on this in March, at which time Andrew Dressel, > director of the MapInfo Professional Product Line, told us > "We have been examining the option of incorporating VBA into > MI Pro for some time. For various reasons, both external and > internal, we don't believe that now is the time to do it. We > may choose to do so in the future." > > Regards, > Scott Elliott > > > -Original Message- > From: [EMAIL PROTECTED] > > Fellow listers, > I have a client who has employed a programmer to do some "sexy" linkages > between Microsoft Access and Mapinfo. As the person producing the spatial > themes (and not very clued up on Map Basic) I have been asked: > 1. How long before Map Basic adopts an object oriented programming > language > (eg Visual Basic) to keep in line with Microsoft Office products? > 2. If Map Basic is never likely to adopt this VB language, what other > mapping program does? > 3. Is Map Basic more than just a fancy macro recorder - can a MapBasic > programmer get the same functionality as say a programmer in the Office > environment? ie what sort of a bang do you get for your buck (Au$1500+) > I welcome any response. > Kim Greenham > -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: Subject: MI Footprints
Maybe these guys can help you. http://www.u-data.com/ Cheers, John Chioles US Standard Data Compusearch/PolkCA http://polk.ca Micromarketing Data & Services Polk US http://www.polk.com Database Engineering & Marketing Technologies > -Original Message- > From: D W [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 19, 1999 2:58 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Subject: MI Footprints > > Hi Gary, does GDT give out free data? ;-) > > Subject: MI Footprints > > Hi all, > > Does anyone know of a good source for US Nationwide government building > locations? > A point file would do, but a file(s) containing building footprint polys > would be best. > Free would be nice too. > > thanx > gary > > > ___ > Get Free Email and Do More On The Web. Visit http://www.msn.com > -- > To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put > "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI "TOO MANY FILES OPEN" during areaoverlap()
Robert, Does this have anything to do with a "FILES=X" statement on some Windows platforms? I know ArcView has the same limitation with themes/shapes. John Chioles US Standard Data Compusearch/PolkCA http://polk.ca Micromarketing Data & Services Polk US http://www.polk.com Database Engineering & Marketing Technologies > -Original Message- > From: Robert Jones [SMTP:[EMAIL PROTECTED]] > Sent: Friday, August 20, 1999 5:19 AM > To: [EMAIL PROTECTED] > Subject: MI "TOO MANY FILES OPEN" during areaoverlap() > > Dear all, > > While performing a series of AreaOverlap calculations, I am getting the > MapInfo error message "Too many files open". > > In reality there are only 3 tables open, so I presume the "files" are > internal temp files. > > Is there anything I can do about this please ? > Thanks, > > Rob Jones, > Head of Geographical Information Unit, > Countryside Council for Wales. > > > -- > To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put > "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI default printer overrides Printer Name in .WOR
Hello MI Printing Gurus; In a MI5.5 WOR with multiple layouts the default printer is used vs. the specified printer in the .WOR. Our temp. answer is to set the default printer as a plotter (in our case) and restarting MapInfo. No error is reported from MI when this occurs, MI just sends the print to the (wrong) default Windows system printer. Nothing else on the print server, etc. has changed. Has anyone else experienced this? Recommended hack? TIA John Chioles Metricom - a world without wires http://www.metricom.com -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
