MI-L Slightly off-topic: Maps - Spain

2004-10-07 Thread Dominic Lowe
Dominic Dominic Lowe Systems Developer The ORC Partnership Goldings Michaels Court Hanney Road Southmoor OX13 5HR Web: www.orcpartnership.com --- This email and attachments are confidential. If you are not the intended recipient, any use, disclosure or

MI-L File is not a valid table..

2004-10-05 Thread Dominic Lowe
ot;File is not a valid table, workspace, or application" I can open the 2nd file fine if I go to Open/File in Mapinfo. I have a feeling that this error started happening after I installed, then uninstalled, 6.5 (while 7.0 was installed). Has anyone encountered this error before?? Many thanks,

RE: MI-L sql select problem

2004-07-19 Thread Dominic Lowe
Sorry, missed Bill's answer! -Original Message- From: Bill Thoen [mailto:[EMAIL PROTECTED] Sent: 17 July 2004 22:18 To: Véronique De Laet Cc: [EMAIL PROTECTED] Subject: Re: MI-L sql select problem On Sat, 17 Jul 2004, Véronique De Laet wrote: > We have a database with elevation values

RE: MI-L sql select problem

2004-07-19 Thread Dominic Lowe
The "Mod" keyword might be what you need. i.e. SELECT * FROM ContourTable WHERE ElevationColumn MOD 5 = 0 This will return all values of Elevation that can be divided exactly by 5. Hope that helps, Dominic -Original Message- From: Véronique De Laet [mailto:[EMAIL PROTECTED] Sent: 17

RE: MI-L Folder Selection (MapBasic)

2004-05-12 Thread Dominic Lowe
Also, if you amend the line: tBrowseInfo.ulFlags = BIF_RETURNONLYFSDIRS + BIF_DONTGOBELOWDOMAIN to read: tBrowseInfo.ulFlags = BIF_RETURNONLYFSDIRS + BIF_DONTGOBELOWDOMAIN + BIF_NEWDIALOGSTYLE and define the constant: Define BIF_NEWDIALOGSTYLE 64 Then you have the option to create a new folde

RE: MI-L Deleting from table

2004-04-23 Thread Dominic Lowe
Hendrik, If you have any indexes on your table try removing these first. (Table | Maintenance | Table Structure - then uncheck the "Indexed" column). Hope that helps Dominic -Original Message- From: Possberg, Hendrik [mailto:[EMAIL PROTECTED] Sent: 23 April 2004 09:33 To: Mapinfo-Lis

MI-L Indexing problems Access/Mapinfo

2004-04-07 Thread Dominic Lowe
Hi all, Has anyone encountered the following problem? Using Mapbasic I'm trying to add and populate a couple of X,Y columns to a table that is stored in Access. The size of this table may vary, but on a large (ish) table (> 20,000 rows) I often get this error "Cannot create an index on a current

RE: MI-L weekend question: ratio between like the crow flies and road distance

2004-04-02 Thread Dominic Lowe
As a fellow cyclist I feel obliged to contribute. A quick check reveals that on my way to work, when I take the shortest route, I get a ratio of 1.26 which is the cube root of 2. On the way home I often take the more scenic square root. Dominic -Original Message- From: B. Thoen [mailto:

RE: MI-L Mapbasic & Windows API question

2004-03-16 Thread Dominic Lowe
Hi Peter, I have a method using the FindWindow API that works for a batch file but with anything more complicated (e.g a VB program with events etc) it's not that good due to the two applications demanding processing power. However if you are just running a batch file it might work for you. The c

MI-L RowIDs and SQL Server

2004-03-11 Thread Dominic Lowe
h Rec n ' This doesn't work Server iHstmt Close End If Has anyone got any ideas about a way round this problem? Many thanks, Dominic Dominic Lowe Systems Developer ORC Data Services www.orcpartnership.com

RE: MI-L FileOpenDialog

2004-01-13 Thread Dominic Lowe
You could bypass the Mapinfo function and try calling the windows dialog box directly using Win32 API calls. This article (link below) is an introduction to the subject of common dialogs - it uses VB, but could be adapted for mapbasic. The interesting bit (for your purposes) starts at the line be

RE: MI-L Check if Mapinfo Professional Open

2003-08-21 Thread Dominic Lowe
Hi Sean, I've had my own battles with the Findwindow API today. You can substitute a vbNullString for the windows ClassName and it works. e.g: Sub FindMapinfo() Dim AppRunning As Integer Dim strCaption As String strCaption = "MapInfo Professional" AppRunning = FindWindow(vbNullString, strCapt