RE: [MI-L] How to remove carriage return from row?

This is only a suggestion, I haven't tried this. What about exporting the Mapinfo tab file to XLS or TXT, and strip them off in there? Then just import back into Mapinfo. Cheers, Peter Zyczynski ___ MapInfo-L mailing list MapInfo-L

RE: [MI-L] Select all objects within a buffer

points on this one!!! ' Now delete the offending point in _foundPoints table. end if fetch next from buffers loop close table _foundPoints end sub '--- Cheers, - Peter Zyczynski -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [MI-L] Labelling numeric fields

, then try this (replace i with your field name): Right$(format$(i, ) , len(format$(i, ))-1) It's a bit of a dragon, but will do the trick. Cheers, Peter Zyczynski -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Baylis Sent: Wednesday, 18 January

RE: [MI-L] Labelling numeric fields

That little trick I sent earlier only works with integers! You'll have to come up with some other idea for decimal and float data types. Cheers, Peter ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com

RE: [MI-L] Reveresing an MBX

... beginners menu EMFullMenu.mnu ... full menu EmIntMenu.mnu ... intermediate menu If you open these files in a text editor, you will see the definition for menus and toolbars. Cheers, Peter Zyczynski -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alex Schulz

RE: [MI-L] Creating Labels using Space as a delimiter....

Try: Left$(MyColumn, InStr(1, MyColumn, )-1) In this instance, InStr() returns the position of the first space character. Subtract 1 from this to exclude the space itself in the label. Cheers, Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [MI-L] SUM Passing parameters to an MBX

: Application.MBApplication(myapp.mbx).Globals(myvar) ), or use the MBApplication's Do method to transfer the values one by one, receiving them with the RemoteMghHandler in the mbx. No need to use DDE, although it's perfectly easy to use as well. Thanks again! Cheers, Peter Zyczynski

[MI-L] Passing parameters to an MBX

Hi All, Is it possible to pass parameters to an MBX? I have to integrate my MBX with a third party application. The third party application will launch my MBX passing an ID number to it, my MBX then assembles a dataset based on this ID number and performs operations on it. If this can't be

RE: [Mapinfo-l] MapInfo-L Blackout

community! Cheers, - Peter Zyczynski Analyst Programmer Insight GIS Hobart, Australia Ph +61 (3) 6234-5833 [EMAIL PROTECTED] www.insightgis.com.au ___ Mapinfo-l mailing list Mapinfo-l@lists.directionsmag.com http

MI-L MB - Show clicked location in multiple coordinate systems?

Hi All, I have custom toolbutton that displayes the position of where the user clicked on the map. It's supposed to display the position in three different coordinate systems. The following code always displays lat/long no matter what I set the coordsys to. Any ideas why? Sub

RE: MI-L MB - Show clicked location in multiple coordinate systems?

= + xLL + , + yLL + CR + GDA94 = + xGDA + , + yGDA + CR + AGD66 = + xAGD + , + yAGD End Sub -Original Message- From: Peter Zyczynski [mailto:[EMAIL PROTECTED] Sent: Tuesday, 4 October 2005 3:32 PM To: 'MapInfo-L' Subject: MI-L MB - Show

MI-L MapX Mobile in Visual Studio 2003 with CFCOM - anyone? anyone? Bueller?

G'day, Just wondering if anyone out there has gone down the brave path of developing with MapX Mobile in Visual Studio 2003 with the CFCOM wrapper class? Overall I've had success with it, but am stuck on writing to TAB files (changing the RowValue.Value property), and was hoping someone out

RE: MI-L Right$ argument 1 has invalid type

Hi Alistair, That's because you can't trim a NUMBER field, you can only run mathematical operations on it. But what you can do is cast the number as a string (STR$), then truncate it (RIGHT$), then cast it back to a number (VAL). Update MYTABLE set MYCOLUMN = val(right$(str$(MYCOLUMN), 4))

RE: SUM: MI-L MB - Can somone compile a MB app for me?

!!! Cheers, Peter Zyczynski -Original Message- From: Peter Zyczynski [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 March 2005 4:49 PM To: MapInfo-L@lists.directionsmag.com Subject: MI-L MB - Can somone compile a MB app for me? Hi all, I have a MB app made up of four modules (MBO files). Each

MI-L MB - Can somone compile a MB app for me?

by this one, never seen anything like it. It's urgent I get this MBX compiled as it's absence is delaying a very large project. Cheers, -- Peter Zyczynski Analyst Programmer Insight GIS Hobart, Australia Ph: (03) 6234-5833 [EMAIL PROTECTED

RE: MI-L ODBC and Access.

and thrilling world of ODBC! Cheers, -- Peter Zyczynski Analyst Programmer Insight GIS Hobart, Australia Ph: (03) 6234-5833 [EMAIL PROTECTED] -Original Message- From: Stephen Smith XS (MC/TKO) [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 March 2005 9:39 PM To: MapInfo-L

MI-L SHIFT-Select, how to make it default behaviour?

appreciated. Cheers, -- Peter Zyczynski Analyst Programmer Insight GIS Hobart, Australia Ph: (03) 6234-5833 [EMAIL PROTECTED] - List hosting provided by Directions Magazine | www.directionsmag.com

MI-L MBX - info tool

will not have any spatial data, just textual. Cheers, Peter Zyczynski - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

MI-L MapX in C#.NET

of the tabControl? Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED] www.insightgis.com.au - List hosting provided by Directions Magazine

RE: MI-L Oracle woes: 9i and MapBasic together ?

download is about 2MB. Have fun! Peter Zyczynski -Original Message- From: Lars V. Nielsen [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 May 2004 11:42 PM To: MapInfo-L Subject: MI-L Oracle woes: 9i and MapBasic together ? Hi all, Being an MS/SQL kinda guy, being thrust onto Oracle 9i

RE: MI-L Drop down list for hotlink

Hi, Unfortunately there's no such functionality built into MI. The way I would do it is to have a separate column for each hotlink in your table. I would then write an MBX with a custom toolbar with a button for each hotlink. Can't supply details as I haven't tried it yet. Good luck Peter

RE: MI-L MapX - raster background not drawing in the right place

Are you viewing an area where two or more rasters are visible on the screen? If you zoom to an area where only one raster is visible does the problem go away? Your problem could be an incorrectly registered raster within your seamless layer. Cheers, Peter -Original Message- From: David

RE: MI-L MBX - Add Column statement - MI crashes in a heap!

queries the better. Cheers, Peter Zyczynski -Original Message- From: Peter Zyczynski [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 2:52 PM To: [EMAIL PROTECTED] Subject: MI-L MBX - Add Column statement - MI crashes in a heap! Help! Trying to update DestinationField in Table_A

Re: MI-L MBX - Add Column statement - MI crashes in a heap!

queries the better. Cheers, Peter Zyczynski -Original Message- From: Peter Zyczynski [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 2:52 PM To: [EMAIL PROTECTED] Subject: MI-L MBX - Add Column statement - MI crashes in a heap! Help! Trying to update DestinationField in Table_A

MI-L MBX - Add Column statement - MI crashes in a heap!

in the Mapbasic window but the effect is the same - CRASHOLA! I have a suspicion that its because I'm joining on RowID, ie: Table_A.RowID = Table_B.MyID So, is it me, is it Mapinfo, or is it both of us? Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833

RE: MI-L Off topic GPS Question - Scotland

of NMEA, these links could be of use: http://www.kh-gps.de/nmea-faq.htm http://www.commlinx.com.au/NMEA_sentences.htm http://www.nmea.org/ Cheers, Peter Zyczynski -Original Message- From: Eagle, David A [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 October 2003 9:29 PM To: [EMAIL PROTECTED

MI-L MapX Mobile - updating row value

Hi, Is there any reason why MapX Mobile won't allow me to update a row value in a native MI table? The table in question is editable and is also the insertion layer. Are there any other criteria/flags that must be set in order to make edit changes to row values? Cheers, Peter Zyczynski

RE: MI-L mapinfo.eval used in VB

TableInfo() takes two arguments, 1 - the table name, 2 what type of info to return about the table ie. TAB_INFO_NROWS. You have to define the TAB_INFO_NRWOS constant in your VB app: Const TAB_INFO_NROWS = 8 Have a look at the MAPBASIC.DEF file for a list of all constants. Cheers, Peter

RE: MI-L MapBasic, OLE Automation and a Delphi DLL

couldn't be found, create new session. oMI := CreateOLEObject('MapInfo.Application'); end; // Do something with Mapinfo oMI.do(yadayaya) end; // Cheers, Peter Zyczynski -Original Message- From: Ian Erickson [mailto

MI-L MB - Passing Alias variables to Functions - bug?

Function '- Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED] www.insightgis.com.au - List hosting

MI-L View entire layer with autolabels

one - I'll go nuts! Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED] www.insightgis.com.au - List hosting provided by Directions Magazine

MI-L MB - system time accuracy

writing deals with rally car racing and needs to keep very accurate time. I'm happy to write a DLL if that's what it takes, although I wonder if this is a limitation of Windows. Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED

MI-L MB - Close table event handler

Hi All, Is there an event handler in MB to detect if a user closed a table? I need to check if the user closes a certain table so I can then disable certain parts of my application/menu options. Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234

MI-L MB - SearchPoint() but with metres?

Hi fellow propellers, I'm after an MB function similar to SearchPoint() except I need to use metres rather than pixels as the tolerance radius. Any ideas? Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED

MI-L Geocoding and Mapinfow.abb file

to shut down Mapinfo and restart it for any changes in the ABB file to become effective? Thanks, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED] www.insightgis.com.au

MI-L Geocoding, preferred data layout?

of geocoding would be great. Thanks, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED] www.insightgis.com.au - List hosting provided by Directions Magazine

RE: MI-L help - error importing dxf to mapinfo

Hi, It is possible that the DXF version you are importing is an Autocad V13 or later DXF. As a suggestion, try getting the owner of the DXF to produce an Autocad V12 compatible DXF. They are usually more stable when reading into MapInfo. Cheers, Peter Zyczynski -Original Message

RE: MI-L Wal mailed you an ecard - MapInfo-L. --- VIRUS!!!

Do not click on this link Just been notified that it will take you to web site that will infect your computer with the Friends Greetings Worm virus. Hope I'm not too late. Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED

RE: MI-L Memory Leak re: CRISP, Paul -Syntegra UK

Evan, Have you tried the NoSelect keyword as Paul Crisp suggested? Eg. select * from whole_Flood_zones where state = 24 into ATEMP NoSelect Cheers, Peter -Original Message- From: Evan MacDougall [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 November 2002 10:28 AM To: MapInfo-L E-mail

RE: MI-L Mapbasic print window question

Hi Rod, You have to check each window and test if it's a Layout window, if it is then print it, something like this: Dim i, WinID as integer For i = 1 to NumWindows() WinID = WindowID(i) If WindowInfo(WinID, WIN_INFO_TYPE) = WIN_LAYOUT then . . 'insert printing code here! .

RE: MI-L Update Column with overlapping polygon tables...

Hi Jeff, I would do it in two steps: 1. Join query: -- Select * from Spots, MunicpleBoundaries Where Spots.obj within MunicpleBoundaries.obj Into TEMP 2. Update the Selection: Update TEMP set muni = name Save table Spots! Cheers, Peter Zyczynski Analyst

RE: MI-L send pictures via mail

Hi Ashley, Try this, It's a bit longwinded but works (in VB5 anyway). Make sure under references you include Microsoft MAPI Controls 5.0 CODE: -- Private Sub SendMessage() Dim MAPISession1 As Object Dim MAPIMessages1 As Object

RE: MI-L Off topic GPS question

Doug, I never actually utilised beacon corrections myself, but FYI the default frequency in my Trimble Pathfinder Controller software is set to 314Khz. It is American software though, so I don't know whether that frequency would also apply here is OZ. Cheers, Peter Zyczynski Analyst

MI-L PDF hotlink web

, the hotlink specified within the workspace was ignored in the final PDF. Also I'm aware that I can introduce these hotlinks manually using the editing features of PDF Writer, but this would be impractical as I have hundreds of pages to produce. Am I pursuing a dead end here? Cheers, Peter Zyczynski

RE: MI-L Creating points from lon/lat having DMS symbols

! Good luck, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6244-7344 Fax: (03) 6244-7028 [EMAIL PROTECTED] www.insightgis.com.au -Original Message- From: Jessie O. Floren [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 2:57 PM To: 'MI-List' Subject: MI-L

RE: MI-L Mapbasic: Window close

the DO-LOOP. DO For i = 1 to NumWindows() WinID = WindowID(i) If WindowInfo(WinID, WIN_INFO_TYPE) = WIN_LAYOUT then Close Window WinID Exit for end if Next Loop Until i NumWindows() End Sub Cheers, Peter

RE: MI-L Connecting to Live ODBC data and refreshing

: 1. You can only have a LIVE link to an Access table (not a query). 2. Changes made in Access won't be reflected in your map window until you pan/zoom/redraw the window. 3. Set the ODBC refresh interval in Access. (Tools/Options/Advanced tab) Cheers, Peter Zyczynski Analyst Programmer

RE: MI-L MB - Select with object variables

, My1) (Mx2, My2) a = s_Layer + .obj Select * From s_ Layer Where a intersects o_Rectangle Into _Intersects Noselect If TableInfo(_Intersects, TAB_INFO_NROWS) 0 then LayerIsVisible = TRUE End if End Function -Original Message- From: Peter Zyczynski

RE: MI-L MB - Select with object variables

a look at Denmark from above! - Videresendt af Peter Møller/Kampsax - 02-08-2002 08:11 - Peter Zyczynski Til: [EMAIL PROTECTED] peterz@insightgcc: is.com.au Vedr.: MI-L MB - Select

MI-L MB - Select with object variables

, MAPPER_INFO_MAXY) Create Rect Into Variable o_Rectangle (Mx1, My1) (Mx2, My2) '*** The following bit must be wrong because '*** it never evaluates to true. If s_Layer intersects o_Rectangle then LayerIsVisible = TRUE end if End Function Peter Zyczynski Analyst

RE: MI-L Trimble Pathfinder Power GPS and Geographic Tracker under Win2000

not an operating system issue like I originally thought. If anyone has anymore info, drop an email! Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6244-7344 Fax: (03) 6244-7028 [EMAIL PROTECTED] www.insightgis.com.au

MI-L Trimble Pathfinder Power GPS and Geographic Tracker under Win2000

bundled with the GPS works fine. Com port issues? Any ideas would be great. (even ridiculous ones) Thanks, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6244-7344 Fax: (03) 6244-7028 [EMAIL PROTECTED] www.insightgis.com.au

RE: MI-L Integrated Alter Table command

bars, the operation can proceed, even if MapInfo is minimized. When MapInfo is hidden or minimised, it halts any operation that displays a progress bar - waiting until it becomes the foreground window again. Hope this helps, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6244

MI-L MBX - text file reading

accompanied by a line feed character (these represent end of line) I need to test for a carriage return with an accompanying line feed. MBX thinks that a single CR is end of line - my nemesis! Thanks, Peter Zyczynski Insight.GIS Australia Ph: (03) 6244-7344 Fax: (03) 6244-7028 [EMAIL PROTECTED

MI-L RE: SUM MI-L MBX - text file reading

Return with a comma. s2 = s2 + , + s1 end if Else s2 = s2 + s1 end if loop Close File #1 Close File #2 End Sub === Thanks to everyone else who responded too. Peter Zyczynski Insight.GIS Australia Ph: (03) 6244

RE: MI-L Select symbols by type

will be selected with the same display properties. It will do exactly what you want. Cheers, Peter Zyczynski Insight.GIS Australia Ph: (03) 6244-7344 Fax: (03) 6244-7028 [EMAIL PROTECTED] -Original Message- From: Luis Baptista [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 17 April 2002 12:42 AM

MI-L MB/Delphi - Varaibles changing for no reason!

; //=== end. Peter Zyczynski Analyst Programmer Landfile Consultancy Australia Ph: (03) 6244-7344 email: [EMAIL PROTECTED] ~~ Advertisement ~~~ Middle East Datasets from LAND INFO Imagery, digital elevation models (DEM), topographic maps, and vector

MI-L MB - Detecting if an MBX is running

Greetings, Can anyone suggest how to detect if a certain MBX is running using MapBasic code, or maybe get a list of all currently running MBXs. Thanks, Peter Zyczynski Analyst Programmer Landfile Consultancy Australia Ph: (03) 6244-7344 email: [EMAIL PROTECTED

RE: MI-L MB / Delphi / OLE - Seeing MBX variables from within Delphi

ShowMessage('MapInfo not running'); End; //try End; - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Zyczynski Sent: Friday, 6 July 2001 12:18 PM To: [EMAIL PROTECTED] Subject

RE: MI-L MB / Delphi / OLE - Seeing MBX variables from within Delphi

PROTECTED]]On Behalf Of Peter Zyczynski Sent: Friday, 6 July 2001 1:34 PM To: [EMAIL PROTECTED] Subject: RE: MI-L MB / Delphi / OLE - Seeing MBX variables from within Delphi Never mind, I worked it out. Here's a snippet if anyone's interested

MI-L MB - MI Runtime installation with MBX app.

of my clients will be running the MBX under MI runtime, and some under MI Pro, and I don't want to be giving instructions to clients on how to re-associate file types with the correct application - not exactly professional is it? :-) Any suggestions greatly appreciated. Thanks, Peter Zyczynski

RE: MI-L MB - Mappershortcut visibility under MI Runtime

Peter Zyczynski wrote: Greetings List, Quick question, I'm porting an MBX from MI Pro to MI Runtime. My application uses a custom MapperShortcut menu, however id doesn't show under MI Runtime. Can anyone tell me what's the equivalent of the Menu bar Show

MI-L MB - Mappershortcut visibility under MI Runtime

Greetings List, Quick question, I'm porting an MBX from MI Pro to MI Runtime. My application uses a custom MapperShortcut menu, however id doesn't show under MI Runtime. Can anyone tell me what's the equivalent of the Menu bar Show command for a MapperShortcut ? Thanks, Peter Zyczynski

RE: MI-L MB/Delphi - Passing strings from MB to Delphi DLL (revisited)

Thanks Marc, Removing the 'var' from the declaration did the trick! Although I had to change the StrLCopy back to the normal StrPCopy. StrLCopy for some reason chopped everything off after the third character (even though the sting was buffered with 100 characters), but StrPCopy works fine.

RE: MI-L MB/Delphi - Passing strings from MB to Delphi DLL (revisited)

Marc, I tried your solution but still get the error message: This program has performed an illegal operation and will be shut down... yada.. yada. yada... Here's my sample MB code... Is there anything obviously wrong? - Include

MI-L MB/Delphi - Passing strings from MB to Delphi DLL (revisited)

in the second example? Peter Zyczynski Analyst Programmer Landfile Consultancy Australia Ph: (03) 6244-7344 email: [EMAIL PROTECTED] ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e

MI-L MB/Delphi - Extracting table info from a .WOR file

the abovementioned details, but was hoping that maybe someone out there has already written an MBX/Delphi4 DLL that does something similar to this. If anyone out there knows of ANY code that can parse ANY info out of the WOR file then I would be happy to hear from you!! Thanks. Peter Zyczynski Analyst

MI-L MB - SelChangedHandler and flickering custom toolbar

you have an active selection and you go and select something else, then the SelChangedHandler procedure gets called twice - just before and just after making the new selection - strange Any ideas would be greatly appreciated. Thanks, Peter Zyczynski Analyst Programmer Landfile Consultancy

MI-L DELPHI: Forcing MI to be the front window from an EXE

ed. Thanks, Peter Zyczynski Analyst Programmer Landfile Consultancy Australia Ph: (03) 6244-7344 email: [EMAIL PROTECTED] ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail

MI-L Delphi: Starting an MBX from within a DLL in an ALREADY OPEN session of MI.

of MapInfo. This is the bit I'm having trouble with. How do I run an MBX in an already open session of MI? Do I get the application handle of the initial session of MI and then somehow force the MBX to run in that Any help or even snippets of code would be most appreciated. Thanks, Peter

MI-L RE: MB/Delphi DLL - Passing user-type parameters by reference - Fixed!

with the maximum number of characters that will be used in the DLL. Thanks for all your help. Peter Zyczynski Analyst Programmer Landfile Consultancy Australia email: [EMAIL PROTECTED] "The one who makes least errors in life is the one who learns the

MI-L MB/Delphi DLL - Passing user-type parameters by reference

changes back inside the MB app. Are there limitations on user type parameters - as far as passing them by-ref goes? Any ideas or work-arounds would be most appreciated. Thanks Peter Zyczynski Analyst Programmer Landfile Consultancy Ph: (03) 6244-7344 email: [EMAIL PROTECTED