Re: MI-L MB Compiler

2003-11-17 Thread B. Thoen
On Tue, 18 Nov 2003, Upinder Mutti wrote:

> This will no doubt sound like a stupid question to many, but please bear
> with my lack of knowledge and naiveity if you dare.  As I am trying to
> get into learning Mapbasic, I'm wondering if there are any options for
> shareware/trialware compilers or any other alternative for where I can
> practise mapbasic, short of purchasing it myself.  Your expert guidance
> and/or ridicule will be much appreciated!  Just out of curiosity, how
> much does a compiler cost?  I s'pose I could always find out from
> MAPINFO but that would be too easy

The only stupid questions are those that are never asked for fear of 
ridicule. What's the worst that can happen? (Use your imagintion...)

But anyway, I believe that you can buy MapBasic and return it within 30
days and get most of your money back if you think it sucks. However, if
you have any GIS programming aptitude at all, I think you'll keep it. It
will open up a whole new world to you. The money, fame and adoration by
your nubile groupies will be hard to give up once you become a MapBasic
programmer.

The real question is are you willing to spend about US$795 to get it?

 - Bill Thoen


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9187



MI-L MB Compiler

2003-11-17 Thread Upinder Mutti
Hello List

This will no doubt sound like a stupid question to many, but please bear
with my lack of knowledge and naiveity if you dare.  As I am trying to
get into learning Mapbasic, I'm wondering if there are any options for
shareware/trialware compilers or any other alternative for where I can
practise mapbasic, short of purchasing it myself.  Your expert guidance
and/or ridicule will be much appreciated!  Just out of curiosity, how
much does a compiler cost?  I s'pose I could always find out from
MAPINFO but that would be too easy

Thanks!

Upinder


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9186



MI-L MI 7 & and multi monitors

2003-11-17 Thread Matt Bolton
Hi all,

This is not a big issue, just a little annoyance that probably has an 
easy fix.

I have both MI 6.5 and MI 7 installed on a PC which has multi monitors.  
When applications are opened they normally do so in the primary (right) 
monitor, and MI 6.5 also does this. However, MI 7 ALWAYS opens up 
maximised in the secondary (left) monitor. meaning that I usually have 
to normalise the window, move it to the other monitor and maximise (only 
takes 2 seconds, just gets annoying).

My experience is that many apps store the coordinates for start up 
window positions in the registry, but I can't find anything appropriate. 
Does anyone know how MI determines start up position (.ini, registry etc.)?

Thanks,

Matt

--
Matt Bolton
Mach 3 IT 
Email  [EMAIL PROTECTED]



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9185


RE: MI-L A question

2003-11-17 Thread Simmonds, Ashley (PTB)
this will most likely be determined by what version of the MI OLE automation
library is referenced in your project.

i can't say for certain as i only have a single version of mapinfo installed
on my machine, but i think having two versions and attempting to register
them both in your project may cause conflicts.  i'm not sure if you can
alias a reference, if you could that would help a great deal.

you could attempt to switch references in code based on what version you
wish to instantiate, however i don't know how to do this as i've never
needed to.

the next option is a bit messy, but do-able.  you could reference MI7
through it's library, but when instantiating MI6 you could do it through a
variant object.  this requires a lot more self-checking and stuff, but it's
the way things used to werk.  this may require that you SHELL mapinfo 6.5
and then use GetObject.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 November 2003 1:34 PM
To: [EMAIL PROTECTED]
Subject: MI-L A question


Thank you very much for your reply at length.And thanks for your kindness
and patience.I get it clear now.

I am sorry I didn't express myself clearly .Could you do me a favor again? I
write a  program using visual basic and run professional through OLE.Under
VB,I create professional object like Set Mi =
CreateObject("MapInfo.Application").But How can I appoint which version of
object to be created. 
Thanks again.

Best regards,
-brozonna

åää: B. Thoen [mailto:[EMAIL PROTECTED]
åéæé: 2003å11æ18æ 9:33
æää: lixiaohuiÃÃ
æé: MapInfo-L
äé: Re: MI-L A question


On Tue, 18 Nov 2003, [gb2312] lixiaohuiÃÃ wrote:

> I sent a question to you yesterday, but I receive several irrelative
> emails just like virus this morning . Could you tell me where can I post
> my question about Professional7.0 and where can I see the answer.

Your message did appear on the MapInfo-L mailing list, but if you did not 
get a response yet it's because either no one here knew the answer or did 
not have time to answer. The "irrelevant" messages you received are other 
messages that are also broadcast over MapInfo-L. That's the way mailing 
lists work; any subscriber can post a message to the list, and all 
subscribers get copies of all messages. Subscribers can then read, answer 
or ignore any messages they please.

If you post a question, it is good list etiquette to post a summary of the 
best answers you receive so that others can benefit from the answers and 
not have to ask the same question again. If you don't get an answer, I'm 
sorry; that's the way it goes. Try asking in a different way. 

BTW, this list is not managed or controlled by MapInfo Corp, so don't get
upset at MapInfo if you don't get immediate (or accurate) answers. It's a 
free and open service set up and used by MapInfo users.

>I intalled both professional6.5 and professional7.0 under
> windows2000 server platform. And I want my application run with the
> version which I appointed,such as professional6.5. How can I do that?

To do this, you need to launch the MapInfo exe for the version you want to 
use and include the path and file name for the application on the command 
line with it. You can use the Run option on the Start menu, or create a 
shortcut that executes the version you want with the app. You may need to 
use complete path names, and also double quotes around the file names.

- Bill Thoen
  MapInfo-L kybernetes



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9184



MI-L A question

2003-11-17 Thread lixiaohui李晓晖
Thank you very much for your reply at length.And thanks for your kindness and 
patience.I get it clear now.

I am sorry I didn't express myself clearly .Could you do me a favor again? I write a  
program using visual basic and run professional through OLE.Under VB,I create 
professional object like Set Mi = CreateObject("MapInfo.Application").But How can I 
appoint which version of object to be created. 
Thanks again.

Best regards,
-brozonna

åää: B. Thoen [mailto:[EMAIL PROTECTED]
åéæé: 2003å11æ18æ 9:33
æää: lixiaohuiÃÃ
æé: MapInfo-L
äé: Re: MI-L A question


On Tue, 18 Nov 2003, [gb2312] lixiaohuiÃÃ wrote:

> I sent a question to you yesterday, but I receive several irrelative
> emails just like virus this morning . Could you tell me where can I post
> my question about Professional7.0 and where can I see the answer.

Your message did appear on the MapInfo-L mailing list, but if you did not 
get a response yet it's because either no one here knew the answer or did 
not have time to answer. The "irrelevant" messages you received are other 
messages that are also broadcast over MapInfo-L. That's the way mailing 
lists work; any subscriber can post a message to the list, and all 
subscribers get copies of all messages. Subscribers can then read, answer 
or ignore any messages they please.

If you post a question, it is good list etiquette to post a summary of the 
best answers you receive so that others can benefit from the answers and 
not have to ask the same question again. If you don't get an answer, I'm 
sorry; that's the way it goes. Try asking in a different way. 

BTW, this list is not managed or controlled by MapInfo Corp, so don't get
upset at MapInfo if you don't get immediate (or accurate) answers. It's a 
free and open service set up and used by MapInfo users.

>I intalled both professional6.5 and professional7.0 under
> windows2000 server platform. And I want my application run with the
> version which I appointed,such as professional6.5. How can I do that?

To do this, you need to launch the MapInfo exe for the version you want to 
use and include the path and file name for the application on the command 
line with it. You can use the Run option on the Start menu, or create a 
shortcut that executes the version you want with the app. You may need to 
use complete path names, and also double quotes around the file names.

- Bill Thoen
  MapInfo-L kybernetes




Re: MI-L A question

2003-11-17 Thread B. Thoen
On Tue, 18 Nov 2003, [gb2312] lixiaohuiÀîÏþêÍ wrote:

> I sent a question to you yesterday, but I receive several irrelative
> emails just like virus this morning . Could you tell me where can I post
> my question about Professional7.0 and where can I see the answer.

Your message did appear on the MapInfo-L mailing list, but if you did not 
get a response yet it's because either no one here knew the answer or did 
not have time to answer. The "irrelevant" messages you received are other 
messages that are also broadcast over MapInfo-L. That's the way mailing 
lists work; any subscriber can post a message to the list, and all 
subscribers get copies of all messages. Subscribers can then read, answer 
or ignore any messages they please.

If you post a question, it is good list etiquette to post a summary of the 
best answers you receive so that others can benefit from the answers and 
not have to ask the same question again. If you don't get an answer, I'm 
sorry; that's the way it goes. Try asking in a different way. 

BTW, this list is not managed or controlled by MapInfo Corp, so don't get
upset at MapInfo if you don't get immediate (or accurate) answers. It's a 
free and open service set up and used by MapInfo users.

>I intalled both professional6.5 and professional7.0 under
> windows2000 server platform. And I want my application run with the
> version which I appointed,such as professional6.5. How can I do that?

To do this, you need to launch the MapInfo exe for the version you want to 
use and include the path and file name for the application on the command 
line with it. You can use the Run option on the Start menu, or create a 
shortcut that executes the version you want with the app. You may need to 
use complete path names, and also double quotes around the file names.

- Bill Thoen
  MapInfo-L kybernetes



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9182



RE: MI-L Importing XL into MI V7.0

2003-11-17 Thread Richard Hill
Hello, Yes, Thanks, 
csv worked OK, no tricks in the data!

Cheers 
Richard

-Original Message-
From: Uffe Kousgaard [mailto:[EMAIL PROTECTED] 
Sent: Monday, 17 November 2003 20:50
To: Mapinfo-L
Subject: Re: MI-L Importing XL into MI V7.0

MI up to v7 can open 32000 rows. MI v7.5 can open up to 65000 rows.

CSV is good choice for importing your data.

- Original Message - 
From: "Richard Hill" <[EMAIL PROTECTED]>
To: "'Mapinfo-List'" <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 7:23 AM
Subject: MI-L Importing XL into MI V7.0


> Hello everyone,
> Is there any limit on the size of an XL spreadsheet that can be opened
> in MI V7.0?
> I tried opening about 33000 lines of assay and geology data and only
the
> first 32500 or so came up in the browser window, the rest come up very
> slowly as zeros as I scroll down.
> Would it be better to import them from a csv or txt file?
>
> Cheers,
> Richard Hill
> Southern Titanium NL
>


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9168



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9181



MI-L A question

2003-11-17 Thread lixiaohui李晓晖
hello,

I sent a question to you yesterday, but I receive several irrelative emails just 
like virus this morning . Could you tell me where can I post my question about 
Professional7.0 and where can I see the answer. 
   My question like this:
 I intalled  both professional6.5 and professional7.0 under windows2000 server 
platform. And I want my application run with  the version which I appointed,such as
  professional6.5. How can I do that? 

Best regards,
-brozonna
  

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9180



Re: MI-L MapBasic and MS Access in the Mystery of the Crashing Ap plication

2003-11-17 Thread Robert Crossley
Bill, Peter,

I think the reason that mapInfo crashes or rebuilds the indices is that it 
is a workaround for a bug that has been in there for a few versions.  
Since version 6.0? or at least when multiuser access to Access tables was 
allowed: If you have several tables in one Access database, and some of 
them had indices on them, and then you opened a couple of them, made an 
edit on one and then even did a selection on another, Mapinfo would crash.

The workaround given at the time was to destroy your indices for all the 
tables in the same database as the table your editing before you edit and 
rebuild them afterwards.  This was of course pretty useless if you needed 
the indices to find the records to edit in less than a geological 
timeframe.  So for me the workaround was to create an array of pending 
edits while I had the indices intact, delete the indices, apply the edits 
and rebuild the indices.

So anyway, a couple of years later, the workaround was embedded into 
MapInfo as a "fix" and it seems to do it automatically.  Less GPFs, but 
still a major performance problem.  The problem still exists sometimes as 
it doesn't always fire off when your running a MapBasic program.  In my 
current app, it has got so bad that I am now storing each table in a 
separate Access database. Next step is back to Mapinfo native tables. So 
much for referential integrity and all that.  If edits are being made 
outside of Mapinfo, then I imagine the triggers to rebuild indices are not 
happening, so you get left with the GPF?

Welcome to my nightmare.

R

On Mon, 17 Nov 2003 18:23:31 +0100, Peter Horsbøll Møller <[EMAIL PROTECTED]> 
wrote:

Hi Bill,

One thing that has annoyed me when creating MB application opening Access
tables thru DAO is that MapInfo sometimes recreates the index on these
tables. I have not been able to figure out when or why. In the beginning 
I
thought it only occured when opening the "tables", but this teory wasn't
completely true.

I have not been able to figure out the entire truth about this issue, 
yet.

Peter Horsbøll Møller
GIS Developer
Geographical Information & IT
COWI A/S
Rugårdsvej 55
DK-5000 Odense
Denmark
Tel +45 6313 5013
Direct  +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk

-Original Message-
From: Bill Thoen [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 5:20 PM
To: MapInfo-L
Subject: MI-L MapBasic and MS Access in the Mystery of the
Crashing Application
I'm trying to debug a rather large MapBasic application that
mysteriously crashes sometimes (and takes MapInfo down with
it.) Evidence from numerous autopsies indicates that it dies
in different places, but sometimes it makes it through the
region of suspect code without a problem. It also works fine
on some machines.
I've heard a rumor that using MS Access with MapBasic
sometimes causes problems like this, and this application
does make heavy use of Access. Does anyone know of specific
issues with MB and Access that I should consider in tracking
down this evil genius of a bug before it strikes again?
--
- Bill Thoen

GISnet, 1401 Walnut St., Suite C, Boulder, CO  80302
tel: 303-786-9961, fax: 303-443-4856
http://www.gisnet.com/



-
List hosting provided by Directions Magazine |
www.directionsmag.com | To unsubscribe, e-mail:
[EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
Message number: 9172

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9173


--

Robert Crossley
Agtrix P/L
9 Short St
New Brighton 2483
Far Southern Queensland
AUSTRALIA
153.549004 E 28.517344 S

P: 02 6680 1309
F: New Connection
M: 0419 718 642
E: [EMAIL PROTECTED]
W: www.agtrix.com
W: www.wotzhere.com
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9179


RE: MI-L Labeling

2003-11-17 Thread Lemah GIS


Dear Michael,

This Hifazat from riyadh.

Dear I have some questions related to mapinfo.
I have one parcel layer with mor ethan 1000 parcels .
I need to maek a layer of parcel number  with sequece of number on parcel
number layer from 1 to 1000.
How can this be done using MapBasic.
Please reply

Thanks in adv.

regards
hifazat

-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 10:43 PM
To: Peter Horsbøll Møller;
Subject: RE:


Thanks Peter it worked.  You guys on this list are awesome!!

I even have the expression set up where I can label all of the roadway
classifications if need be:
Left$(ROADNAME, (Int(CLASSIFICATION = any ("mja",”mjc”,”mnc”,”mna”)) *
Len(ROADNAME)))


-Original Message-
From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 12:23 PM
To: 'Michael Smith'; MapInfo-L
Subject: RE: MI-L Labeling


Try this neat little label expression

Left$(CLASSIFICATION, (Int(CLASSIFICATION = "mja") * Len(CLASSIFICATION)))

This could also be used to label the roads with the road name if the
classification is "mja":
Left$(ROADNAME, (Int(CLASSIFICATION = "mja") * Len(ROADNAME)))

The trick is that Int() returns the integer value of the expression in side
the parensis. So here you enter a true/false expression.
If the expression is true the Int() will return 1 else it returns 0. The
value returned is used to decide whether the entire label value should be
returned or no string at all. The Left$() function returns n chars starting
from left.

Only your imagination - and MapInfo max length of label expressions - sets
the limit for whats possible.

Here is a neat example I'm using in a special application:
Left$(MARKNR, Len(MARKNR) * Int(MARKNR <> "HJÆLPEOBJEKT")) + Chr$(10) +
Left$(MAALEMETODE, Len(MAALEMETODE) * Int(InStr(1, UCase$(MARKNR),
"FRADRAG") = 0 and MARKNR <> "HJÆLPEOBJEKT" and InStr(1, UCase$(MARKNR),
"**")=0))

Does it make any sence ? ;-)

Peter Horsbøll Møller
GIS Developer
Geographical Information & IT

COWI A/S
Rugårdsvej 55
DK-5000 Odense
Denmark

Tel +45 6313 5013
Direct  +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk


> -Original Message-
> From: Michael Smith [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 7:01 PM
> To: MapInfo-L
> Subject: MI-L Labeling
>
>
> Is there a way to label in MapInfo 7.0 using some type of if,
> then (if attribute field equals certain value then label).
> What I need to do seems simple but I just can't seem to figure it out.
>
> I have a streets centerline file with an attribute field
> classifing the type of roadway each segment is.  In this
> attribute field, I have 4 classifications of data (mja, mna,
> mjc, mnc).  If I want to label only streets with attribute
> data of mja and not label the other streets segments how can
> I do this?
>
> Thanks in advance.
>
> Michael Smith, Planner II
> City of San Angelo
> Planning & Development
> 325.657.4210 Fax: 325.481.2648
> Email: [EMAIL PROTECTED]
>
>
>
> -
> List hosting provided by Directions Magazine |
> www.directionsmag.com | To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> Message number: 9174
>
>




-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9177




-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9178



RE: MI-L Labeling

2003-11-17 Thread Michael Smith
Thanks Peter it worked.  You guys on this list are awesome!!

I even have the expression set up where I can label all of the roadway
classifications if need be:
Left$(ROADNAME, (Int(CLASSIFICATION = any ("mja",”mjc”,”mnc”,”mna”)) *
Len(ROADNAME)))


-Original Message-
From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 12:23 PM
To: 'Michael Smith'; MapInfo-L
Subject: RE: MI-L Labeling


Try this neat little label expression

Left$(CLASSIFICATION, (Int(CLASSIFICATION = "mja") * Len(CLASSIFICATION)))

This could also be used to label the roads with the road name if the
classification is "mja":
Left$(ROADNAME, (Int(CLASSIFICATION = "mja") * Len(ROADNAME)))

The trick is that Int() returns the integer value of the expression in side
the parensis. So here you enter a true/false expression.
If the expression is true the Int() will return 1 else it returns 0. The
value returned is used to decide whether the entire label value should be
returned or no string at all. The Left$() function returns n chars starting
from left.

Only your imagination - and MapInfo max length of label expressions - sets
the limit for whats possible.

Here is a neat example I'm using in a special application:
Left$(MARKNR, Len(MARKNR) * Int(MARKNR <> "HJÆLPEOBJEKT")) + Chr$(10) +
Left$(MAALEMETODE, Len(MAALEMETODE) * Int(InStr(1, UCase$(MARKNR),
"FRADRAG") = 0 and MARKNR <> "HJÆLPEOBJEKT" and InStr(1, UCase$(MARKNR),
"**")=0))

Does it make any sence ? ;-)

Peter Horsbøll Møller
GIS Developer
Geographical Information & IT

COWI A/S
Rugårdsvej 55
DK-5000 Odense
Denmark

Tel +45 6313 5013
Direct  +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk


> -Original Message-
> From: Michael Smith [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 7:01 PM
> To: MapInfo-L
> Subject: MI-L Labeling
>
>
> Is there a way to label in MapInfo 7.0 using some type of if,
> then (if attribute field equals certain value then label).
> What I need to do seems simple but I just can't seem to figure it out.
>
> I have a streets centerline file with an attribute field
> classifing the type of roadway each segment is.  In this
> attribute field, I have 4 classifications of data (mja, mna,
> mjc, mnc).  If I want to label only streets with attribute
> data of mja and not label the other streets segments how can
> I do this?
>
> Thanks in advance.
>
> Michael Smith, Planner II
> City of San Angelo
> Planning & Development
> 325.657.4210 Fax: 325.481.2648
> Email: [EMAIL PROTECTED]
>
>
>
> -
> List hosting provided by Directions Magazine |
> www.directionsmag.com | To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> Message number: 9174
>
>




-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9177



RE: MI-L Labeling

2003-11-17 Thread Peter Horsbøll Møller
Try this neat little label expression

Left$(CLASSIFICATION, (Int(CLASSIFICATION = "mja") * Len(CLASSIFICATION)))

This could also be used to label the roads with the road name if the
classification is "mja":
Left$(ROADNAME, (Int(CLASSIFICATION = "mja") * Len(ROADNAME)))

The trick is that Int() returns the integer value of the expression in side
the parensis. So here you enter a true/false expression.
If the expression is true the Int() will return 1 else it returns 0. The
value returned is used to decide whether the entire label value should be
returned or no string at all. The Left$() function returns n chars starting
from left.

Only your imagination - and MapInfo max length of label expressions - sets
the limit for whats possible.

Here is a neat example I'm using in a special application:
Left$(MARKNR, Len(MARKNR) * Int(MARKNR <> "HJÆLPEOBJEKT")) + Chr$(10) +
Left$(MAALEMETODE, Len(MAALEMETODE) * Int(InStr(1, UCase$(MARKNR),
"FRADRAG") = 0 and MARKNR <> "HJÆLPEOBJEKT" and InStr(1, UCase$(MARKNR),
"**")=0))

Does it make any sence ? ;-)

Peter Horsbøll Møller
GIS Developer
Geographical Information & IT
 
COWI A/S
Rugårdsvej 55
DK-5000 Odense
Denmark
 
Tel +45 6313 5013
Direct  +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk


> -Original Message-
> From: Michael Smith [mailto:[EMAIL PROTECTED] 
> Sent: Monday, November 17, 2003 7:01 PM
> To: MapInfo-L
> Subject: MI-L Labeling
> 
> 
> Is there a way to label in MapInfo 7.0 using some type of if, 
> then (if attribute field equals certain value then label).  
> What I need to do seems simple but I just can't seem to figure it out.
> 
> I have a streets centerline file with an attribute field 
> classifing the type of roadway each segment is.  In this 
> attribute field, I have 4 classifications of data (mja, mna, 
> mjc, mnc).  If I want to label only streets with attribute 
> data of mja and not label the other streets segments how can 
> I do this?
> 
> Thanks in advance.
> 
> Michael Smith, Planner II
> City of San Angelo
> Planning & Development
> 325.657.4210 Fax: 325.481.2648
> Email: [EMAIL PROTECTED]
> 
> 
> 
> -
> List hosting provided by Directions Magazine | 
> www.directionsmag.com | To unsubscribe, e-mail: 
> [EMAIL PROTECTED]
> For additional commands, e-mail: 
> [EMAIL PROTECTED]
> Message number: 9174
> 
> 

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9176



Re: MI-L Labeling

2003-11-17 Thread Jorge Cordero
Hi Michael,

In the layer control choose: Label >> Label With >> Expresion and the text
box write: TYPE = "MJA"

TYPE replace to name of column with attribute data




Jorge Cordero

- Original Message - 
From: "Michael Smith" <[EMAIL PROTECTED]>
To: "MapInfo-L" <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 12:01 PM
Subject: MI-L Labeling


> Is there a way to label in MapInfo 7.0 using some type of if, then (if
> attribute field equals certain value then label).  What I need to do seems
> simple but I just can't seem to figure it out.
>
> I have a streets centerline file with an attribute field classifing the
type
> of roadway each segment is.  In this attribute field, I have 4
> classifications of data (mja, mna, mjc, mnc).  If I want to label only
> streets with attribute data of mja and not label the other streets
segments
> how can I do this?
>
> Thanks in advance.
>
> Michael Smith, Planner II
> City of San Angelo
> Planning & Development
> 325.657.4210 Fax: 325.481.2648
> Email: [EMAIL PROTECTED]
>
>
>
> -
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> Message number: 9174
>
>


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9175



MI-L Labeling

2003-11-17 Thread Michael Smith
Is there a way to label in MapInfo 7.0 using some type of if, then (if
attribute field equals certain value then label).  What I need to do seems
simple but I just can't seem to figure it out.

I have a streets centerline file with an attribute field classifing the type
of roadway each segment is.  In this attribute field, I have 4
classifications of data (mja, mna, mjc, mnc).  If I want to label only
streets with attribute data of mja and not label the other streets segments
how can I do this?

Thanks in advance.

Michael Smith, Planner II
City of San Angelo
Planning & Development
325.657.4210 Fax: 325.481.2648
Email: [EMAIL PROTECTED]



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9174



RE: MI-L MapBasic and MS Access in the Mystery of the Crashing Ap plication

2003-11-17 Thread Peter Horsbøll Møller
Hi Bill,

One thing that has annoyed me when creating MB application opening Access
tables thru DAO is that MapInfo sometimes recreates the index on these
tables. I have not been able to figure out when or why. In the beginning I
thought it only occured when opening the "tables", but this teory wasn't
completely true.

I have not been able to figure out the entire truth about this issue, yet.

Peter Horsbøll Møller
GIS Developer
Geographical Information & IT
 
COWI A/S
Rugårdsvej 55
DK-5000 Odense
Denmark
 
Tel +45 6313 5013
Direct  +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk


> -Original Message-
> From: Bill Thoen [mailto:[EMAIL PROTECTED] 
> Sent: Monday, November 17, 2003 5:20 PM
> To: MapInfo-L
> Subject: MI-L MapBasic and MS Access in the Mystery of the 
> Crashing Application
> 
> 
> I'm trying to debug a rather large MapBasic application that 
> mysteriously crashes sometimes (and takes MapInfo down with 
> it.) Evidence from numerous autopsies indicates that it dies 
> in different places, but sometimes it makes it through the 
> region of suspect code without a problem. It also works fine 
> on some machines.
> 
> I've heard a rumor that using MS Access with MapBasic 
> sometimes causes problems like this, and this application 
> does make heavy use of Access. Does anyone know of specific 
> issues with MB and Access that I should consider in tracking 
> down this evil genius of a bug before it strikes again?
> 
> --
> - Bill Thoen
> 
> GISnet, 1401 Walnut St., Suite C, Boulder, CO  80302
> tel: 303-786-9961, fax: 303-443-4856
> http://www.gisnet.com/
> 
> 
> 
> 
> -
> List hosting provided by Directions Magazine | 
> www.directionsmag.com | To unsubscribe, e-mail: 
> [EMAIL PROTECTED]
> For additional commands, e-mail: 
> [EMAIL PROTECTED]
> Message number: 9172
> 
> 

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9173



MI-L MapBasic and MS Access in the Mystery of the Crashing Application

2003-11-17 Thread Bill Thoen
I'm trying to debug a rather large MapBasic application that
mysteriously crashes sometimes (and takes MapInfo down with it.)
Evidence from numerous autopsies indicates that it dies in
different places, but sometimes it makes it through the region of
suspect code without a problem. It also works fine on some
machines.

I've heard a rumor that using MS Access with MapBasic sometimes
causes problems like this, and this application does make heavy
use of Access. Does anyone know of specific issues with MB and
Access that I should consider in tracking down this evil genius
of a bug before it strikes again?

--
- Bill Thoen

GISnet, 1401 Walnut St., Suite C, Boulder, CO  80302
tel: 303-786-9961, fax: 303-443-4856
http://www.gisnet.com/




-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9172



RE: MI-L Export to *.TXT

2003-11-17 Thread Peter Horsbøll Møller
I would recommend that you just use the Print #nFile, statement to print
directly to a file.

Start by opening the file using "Open File .. for Output .."
Now you can create string to print using you varables
And filanlly the "Close File #..." Closes the file.

Peter Horsbøll Møller
GIS Developer
Geographical Information & IT
 
COWI A/S
Rugårdsvej 55
DK-5000 Odense
Denmark
 
Tel +45 6313 5013
Direct  +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk


> -Original Message-
> From: Eagle, David A [mailto:[EMAIL PROTECTED] 
> Sent: Monday, November 17, 2003 2:41 PM
> To: [EMAIL PROTECTED]
> Subject: MI-L Export to *.TXT
> 
> 
> Hello Mappers,
> 
> On this dull and dreary Monday I would like to output some 
> data to a TXT file or similar (CSV, DBF)...
> 
> I have written some MB code to report info on a point of 
> interest. When clicked on, attribute info is passed into 
> variables and then displayed on a custom dialog. I want the 
> option to click on a button on that dialog to output this 
> data to a file that can be manipulated elsewhere.
> 
> All the values are currently held in variables other than 
> some unique values, I'd like to output them to a text file as follows:
> 
>   Unique1 Unique2
> Unique3   Var1Var2
> Unique4   Var3Var4
> Unique5   Var5Var6
> 
> The TXT file would be comma separated like this:
> 
>  ,Unique1,Unique2
> Unique3,Var1,Var2
> Unique4   ,Var3,Var4
> Unique5   ,Var5,Var6
> 
> My initial thoughts are to create a temporary table which I 
> subsequently delete, into which I create new rows updated 
> with the values above. I could then probably initiate 
> Table>Export through MB code to output to TXT??
> 
> Does anyone have any thoughts or tidier solutions? Am I going 
> the long way down the garden path again?
> 
> Best Regards, David
> 
> 
> 
> This email and any attached files are confidential and 
> copyright protected. If you are not the addressee, any 
> dissemination of this communication is strictly prohibited. 
> Unless otherwise expressly agreed in writing, nothing stated 
> in this communication shall be legally binding.
> 
> 
> 
> -
> List hosting provided by Directions Magazine | 
> www.directionsmag.com | To unsubscribe, e-mail: 
> [EMAIL PROTECTED]
> For additional commands, e-mail: 
> [EMAIL PROTECTED]
> Message number: 9170
> 
> 

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9171



MI-L Export to *.TXT

2003-11-17 Thread Eagle, David A
Hello Mappers,

On this dull and dreary Monday I would like to output some data to a TXT
file or similar (CSV, DBF)...

I have written some MB code to report info on a point of interest. When
clicked on, attribute info is passed into variables and then displayed on a
custom dialog. I want the option to click on a button on that dialog to
output this data to a file that can be manipulated elsewhere.

All the values are currently held in variables other than some unique
values, I'd like to output them to a text file as follows:

Unique1 Unique2
Unique3 Var1Var2
Unique4 Var3Var4
Unique5 Var5Var6

The TXT file would be comma separated like this:

 ,Unique1,Unique2
Unique3,Var1,Var2
Unique4 ,Var3,Var4
Unique5 ,Var5,Var6

My initial thoughts are to create a temporary table which I subsequently
delete, into which I create new rows updated with the values above. I could
then probably initiate Table>Export through MB code to output to TXT??

Does anyone have any thoughts or tidier solutions? Am I going the long way
down the garden path again?

Best Regards, David



This email and any attached files are confidential and copyright protected.
If you are not the addressee, any dissemination of this communication is
strictly prohibited. Unless otherwise expressly agreed in writing, nothing
stated in this communication shall be legally binding.



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9170



RE: MI-L Importing XL into MI V7.0

2003-11-17 Thread Peter Horsbøll Møller
MapInfo 7.0 or older can only import the first 32K records from an Excel
file.
MapInfo 7.5 can import all 64K (!!) records

Peter Horsbøll Møller
GIS Developer
Geographical Information & IT
 
COWI A/S
Rugårdsvej 55
DK-5000 Odense
Denmark
 
Tel +45 6313 5013
Direct  +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk


> -Original Message-
> From: Richard Hill [mailto:[EMAIL PROTECTED] 
> Sent: Monday, November 17, 2003 7:23 AM
> To: 'Mapinfo-List'
> Subject: MI-L Importing XL into MI V7.0
> 
> 
> Hello everyone, 
> Is there any limit on the size of an XL spreadsheet that can 
> be opened in MI V7.0? I tried opening about 33000 lines of 
> assay and geology data and only the first 32500 or so came up 
> in the browser window, the rest come up very slowly as zeros 
> as I scroll down. Would it be better to import them from a 
> csv or txt file?
>  
> Cheers, 
> Richard Hill
> Southern Titanium NL
> 

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9169



Re: MI-L Importing XL into MI V7.0

2003-11-17 Thread Uffe Kousgaard
MI up to v7 can open 32000 rows. MI v7.5 can open up to 65000 rows.

CSV is good choice for importing your data.

- Original Message - 
From: "Richard Hill" <[EMAIL PROTECTED]>
To: "'Mapinfo-List'" <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 7:23 AM
Subject: MI-L Importing XL into MI V7.0


> Hello everyone,
> Is there any limit on the size of an XL spreadsheet that can be opened
> in MI V7.0?
> I tried opening about 33000 lines of assay and geology data and only
the
> first 32500 or so came up in the browser window, the rest come up very
> slowly as zeros as I scroll down.
> Would it be better to import them from a csv or txt file?
>
> Cheers,
> Richard Hill
> Southern Titanium NL
>


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9168



MI-L unsubscribe

2003-11-17 Thread David Bell


**
This email and any attachments have been checked for viruses.
It is confidential and intended solely for the use of the addressee. 
If you have received this in error please notify the sender
**


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9167



MI-L Importing XL into MI V7.0

2003-11-17 Thread Richard Hill
Hello everyone, 
Is there any limit on the size of an XL spreadsheet that can be opened
in MI V7.0?
I tried opening about 33000 lines of assay and geology data and only the
first 32500 or so came up in the browser window, the rest come up very
slowly as zeros as I scroll down.
Would it be better to import them from a csv or txt file?
 
Cheers, 
Richard Hill
Southern Titanium NL