List of Contributions

James Nolet

Dooley Mitchell & Morrison Pty Ltd
MapInfo Pro 17 Beta

Contact Details

Dooley Mitchell & Morrison Pty Ltd
Australia

My Content

1 to 20 of 50+ total
Posted By James Nolet Dec 3, 2019 10:11 PM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hi Kurt, Is the "Run Application" command what you are after?  This allows you to run one MBX program from another. ------------------------------ James Nolet Dooley Mitchell & Morrison Pty Ltd Mentone, VIC, Australia ------------------------------
Posted By James Nolet Nov 20, 2019 4:50 PM
Found In Egroup: MapInfo Pro
\ view thread
In that case, draw a new polygon that crosses the line you would like removed.  Once you have done this, set the large polygon as the target (Ctrl+T), then select the new polygon, and choose the Erase Target tool from the Spatial tab. When drawing the new polygon, try to snap to the existing nodes ...
Posted By James Nolet Nov 20, 2019 7:39 AM
Found In Egroup: MapInfo Pro
\ view thread
Hi Richard, You can perform a "Save Copy As" from the Home tab.  When the "Save Copy of Table As" dialogue appears, first enter a new name for the table then click on the Projection button to select the projection you are after. ------------------------------ James Nolet Dooley Mitchell & Morrison Pty ...
Posted By James Nolet Nov 20, 2019 7:35 AM
Found In Egroup: MapInfo Pro
\ view thread
Hi Richard, Try the "Split Target using Polyline" tool.  1. Draw a polyline through the polygon where you want it to be split.  2. Select the polygon and press Ctrl+T to set the polygon as the target of the editing operation. 3. Select the polyline. 4. From the Spatial Tab, choose "Split Target using ...
Posted By James Nolet Nov 20, 2019 7:21 AM
Found In Egroup: MapInfo Pro
\ view thread
Hi Hannah, It might be worth finding out what the transport company is using as the exact start and end points for their measurement.  For example, are they measuring from the school gates to your driveway?  Could they provide you with a diagram of their results?  You could then compare this with Google.   ...
Posted By James Nolet Oct 30, 2019 12:09 AM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
I have now implemented the workaround by: Amending the SQL queries in SQL Server to include a spatial component via a join to property polygons. Resolving the 32-character table name limit imposed by MapInfo Pro on mappable tables.  I wanted the views to be MapInfo-mappable because my preference is ...
Posted By James Nolet Oct 24, 2019 12:58 AM
Found In Egroup: MapInfo Pro
\ view thread
That's no problem - I'm glad I could help. ------------------------------ James Nolet Dooley Mitchell & Morrison Pty Ltd Mentone, VIC, Australia ------------------------------
Posted By James Nolet Oct 24, 2019 12:21 AM
Found In Egroup: MapInfo Pro
\ view thread
Hi Mitchel, It looks as though MapInfo can only handle one DDE conversation at a time.  I gave this a go in MapBasic 12.5, MapInfo 17 and the same thing happened.  If you execute the  DDERequest$ in App_B before the DDE conversation is initiated by App_A (e.g. within the Main routine of App_B) it succeeds.  ...
Posted By James Nolet Oct 10, 2019 2:07 AM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Against the parcel/property polygon layer I have configured a number of databinds that extract from non-spatial SQL Server tables for exporting to CSV, as shown: These databinds would be most useful when used after having performed a query (such as selecting all polygons within a circle annotation).  ...
Posted By James Nolet Sep 11, 2019 10:13 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Did you try the solution by @Timothy Mashford ?  If that didn't work, you might need to supply a sample of your data. Do you have a field in  All_VideoTrackPts called "myTrackName"? ​​ ------------------------------ James Nolet Dooley Mitchell & Morrison Pty Ltd Mentone, VIC, Australia ------------- ...
Posted By James Nolet Sep 9, 2019 8:03 PM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Timothy - Yes, I think quite a bit of tidying up is required. Peter - More details might help us (such as what tables you are working with and the structure of these tables). Warren - I tend to use Run Command and avoid aliases altogether! ------------------------------ James Nolet Dooley Mitchell & ...
Posted By James Nolet Sep 9, 2019 5:51 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hi Warren, I think you're on the right track.  I was assuming that the Select statement was intending to select from the current selection, but see now that the value retrieved from the "TrackName" field of the current selection will be used to select from the " All_VideoTrackPts" table. ----------- ...
Posted By James Nolet Sep 8, 2019 11:16 PM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hi Peter, There are two errors I noticed in your code. 1.  sQuery needs to be defined as an Alias 2. In the select statement, I think you want to query from the  sQuery   temp table rather than "All_VideoTrackPts".  Change the code to: Select * from sQuery   where myTrackName = "myTrackname" into myQuery ...
Posted By James Nolet Jul 22, 2019 5:00 AM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hi Andy, As well as exporting a CSV with the data, would it be possible to create an image file and include the file's path in the CSV as well?  It seems that an URL to an image can be included in the Word mail merge.  See the " Merge with Pictures" heading within https://www.smallbusinesscomputing. ...
Posted By James Nolet Jul 10, 2019 2:48 AM
Found In Egroup: MapInfo Pro Developers User Group
\ view thread
Hi Andrew, Did you try zipping the file before uploading?  Only certain file types are accepted, and zip seems to be one of them (but not .MBX). ------------------------------ James Nolet Dooley Mitchell & Morrison Pty Ltd ------------------------------
Posted By James Nolet Jul 9, 2019 9:24 PM
Found In Egroup: MapInfo Pro
\ view thread
Hi Andrew, Good to hear!  Peter can now continue to enjoy his vacation! (Peter, it might be that the Ribbonlib routine has changed - a previous version added the specified group if it was missing but the later version does not.  This is just a guess though.) ------------------------------ James Nolet ...
Posted By James Nolet Jul 9, 2019 3:00 AM
Found In Library: Mapinfo Pro
Posted By James Nolet Jul 9, 2019 3:00 AM
Found In Egroup: MapInfo Pro
\ view thread
Hi Andrew, This functionality is available in the WindowHelper tool (available from the MapInfo Marketplace): However, before I discovered this, I investigated the error you are seeing and managed to program in a quick fix and recompile the mbx for MapInfo version 12.5 and above. @Peter Horsbøll Møller ...
Posted By James Nolet Jun 27, 2019 10:48 PM
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hi Dave, Yes, this is on behalf of Benalla.  Thanks for your help there.  We were very close!  Someone from your Services team has contacted me and we are now waiting to hear back about what a solution to this entails.  However, as we are keen to progress I was pursuing all options, hence this post to ...
Posted By James Nolet Jun 13, 2019 11:33 PM
Found In Egroup: MapInfo Pro
\ view thread
Hi George, You should check out the IIF function.  For example, use this in your label expression: IIF(Type like "%Valve%", Type, "") If Type contains "Valve", then the Type field will be used as the label, else an empty string will be used. ------------------------------ James Nolet Dooley Mitchell ...