Re: [MI-L] How do I obtain the names of tables in a Microsoft Access database via MapBasic?

2006-08-11 Thread Lars I. Nielsen (GisPro)
Hi Greg, MS/SQL is very much like Access, and MS/SQL keeps the tables list in a special system table called sysobjects. One can query this table as any other table. I wondered whether Access didn't have a similar construct, and under that assumption, I google'd for it, and found this query :

[MI-L] How do I obtain the names of tables in a Microsoft Access database via MapBasic?

2006-08-11 Thread Greg Goodall
I want to display to my users a MultiListBox containing the names of the tables contained in a Microsoft Access Database.  I plan on using the FileOpenDlg() function where the user will identify the name of the Access database as below.   Dim s_database_name As String s_database_name = F

[MI-L] MapInfo-L Reminder

2006-08-11 Thread Bill Thoen
To: MapInfo-L@lists.directionsmag.com From: [EMAIL PROTECTED] Subject: MapInfo-L Reminder This is just a reminder to help you manage your MapInfo-L subscription. This will be posted automatically each week, and please feel free to respond with suggestions or improvements. Check out the MapInfo-

[MI-L] Embedding non-thematic legends?

2006-08-11 Thread Mats Elfström
How do you do that? I must be blind because I can't seem to figure that out. I have a number of very active legends, but the little embedded window it says just: No active legend. Hälsning / Best regards Mats.E FB Engineering AB Södra Förstadsgatan 26 211 43 Malmö Tel: 0

RE: [MI-L] distance between points and a line

2006-08-11 Thread Joe Nunn
Hi Alison The Distance calculator tool (comes free with mapinfo) can do this. Just open it from Tool Manager. Quite a versatile tool. Best Regards Joe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alison Deegan Sent: 11 August 2006 09:34 To: MapInfo-L

RE: [MI-L] Road Intersections

2006-08-11 Thread Joe Nunn
Hi Joel   This appears to be what you are after: http://www.directionsmag.com/files/index.php/view/249 Includes the source code so you can see the sql involved.   Regards   Joe   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cohen, Joel Sent: 11 August 200

[MI-L] distance between points and a line

2006-08-11 Thread Alison Deegan
Dear all, I have a long line representing coastline in table 1 and many points in table 2. I would like to update table 2 with the shortest distance between each point and the coast. The tools I have found so far seem to calculate the distance to the centroid of the coast polyline. Any suggesti