SUM [MI-L] select records by string within text

2006-01-12 Thread Alistair Hart
Hi (again) folks. Thankyou to all those that responded prior to my own reply being posted with the solution I found. Nearly every response suggested I try using the 'Like' operator with the '%' wildcard character. Eg. Where Facility_Name Like "%health%" Thankyou very much for this idea - I

[MI-L] Re: MI-L select records by string within text

2006-01-12 Thread Alistair Hart
Hi again, The friday fog has lifted (no doubt courtesy of that last caffeine blast...). I found a reference to a function called the InStr Function in the MIPro User Guide that allows me to do precisely what I need. In this function (called within the Query>Select or Query>SQL select dialogu

[MI-L] select records by string within text

2006-01-12 Thread Alistair Hart
Hi Folks, Having a Friday 'foggy thinking' moment here... and not having any luck with archive or MI documentation... Can anyone tell me what command one would use to select records where the data within one column included particular text? I have a couple of separate tables I need this fun

Re: [MI-L] Using a variable Text string in a Layout

2006-01-12 Thread David Jerrard
Hi Mats, I have found it useful (not ideal, perhaps, but useful) to "recycle" some layouts for printout using workspaces. For example, a workspace with the following clause in the "Layout" section: Create Text FormatDate$(CurDate()) + " " + Time(24) (0.5313,11.1493) (2.3097,11.341)

Re: [MI-L] voronoi polgon

2006-01-12 Thread Robert DeRubeis
I finally found the reason for the incorrectly shaped voronoi polygons. It seems the Projection your points are in effects the shape of the voronoi polygons created. The points table I used to create the voronoi polygons from was in a Longitude/Latitude Projection, which created the inaccuracies.

RE: [MI-L] Hot Spot Mapping

2006-01-12 Thread Terry McDonnell
Andrew Try the below. I've excised it and changed it to suit from my work on similar stuff so I can't guarantee that there's no bugs in it. It's just the general idea for you to work on. As I read your query, you wish to identify recs of a certain (or above in the code's case) area, and mark t

RE: [MI-L] Hot Spot Mapping

2006-01-12 Thread Kent Hargesheimer
Andrew: I'd suggest you take a look at Spatial Insights' Trend Map product that works with MapInfo. More info is available at http://www.gis4less.com/catalog/product_info.php?cPath=6_16&products_id=89 Kent Hargesheimer Geographic Enterprises http://www.geo-e.com tel 919.341.1535 -Origina

Re: [MI-L] voronoi polgon

2006-01-12 Thread Robert DeRubeis
I got the same results with only 26 points as with all 15,000 so I guess the number of points doesn't seem to matter. Something seems to be off a little in MI Pro as to how it creates the voronoi polygons. -Bob Peter Horsbøll Møller <[EMAIL PROTECTED]> on Thursday, January 12, 2006 at 9:17 AM -0

Re: [MI-L] voronoi polgon

2006-01-12 Thread Robert DeRubeis
I have used the Distance Calculator in MI Pro v7.8 and that gave the correct closest store location. But I'm wanting to assign some 58,000 customers to the closest store. The number of customers will vary depending on how many customers fall within that particular voronoi polygon, which is anywhe

[MI-L] Using a variable Text string in a Layout

2006-01-12 Thread Mats Elfström
Hi All! I am looking for a way to update textstrings in an otherwise static and manually created layout in a static workspace. I am aware of the MapBasic commands CurDate() and FormatDate$() to programmatically achieve the same result. It is not possible to create the map and layout programatica

[MI-L] Exporting GML and GZ

2006-01-12 Thread bob young
That sounds interesting. However GML is part of OGC standards, this is one of the reasons it was chosen by Ordnance Survey. It sounds like XML within ZIP is going to be similar, and I could perhaps do some mods. later after getting GML/GZ cracked. I've not worked with Linux at all. Cheers Bob

RE: [MI-L] 2 GB limit increased to 16 Terrabytes

2006-01-12 Thread SCISOFT
Dare I suggest you write to the XPS format, when it's finalized / announced? That's the Windows Vista Print format (XML within linked ZIP package), for Word 12 + printing + exchangeable "PDF-replacement" format. New printers will be released with special XPS printer drivers. Imagine it as a bette

Re: [MI-L] 2 GB limit increased to 16 Terrabytes

2006-01-12 Thread bob young
I'm thinking about writing a free TAB to GML translator following the interest yesterday. If I do I'll send you a copy so you can see the structures. It's very verbose but ZIPS up nicely , and I could write it straight to the GZ format to keep it nice and fast! Regards Bob In message <[EMAIL P