RE: MI-L selecting blank records?

[PEM]

Hi Brian,

If you want to select records where a text column has no values do the
following:

Select *
>From 
where  = ""

 is the name of your table
 is the name of your column

HTH
Peter

Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
Kampsax A/S - GIS Software & Solutions
Rugaardsvej 55, 5000 Odense, DK
tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
mailto:[EMAIL PROTECTED]
www.kampsax-gis.dk and www.kampsax.dk
Authorized MapInfo Partner & Distributor in Denmark and Norway.

Se mere om Dansk MapInfo Brugerkonference på 
http://www.kampsax-gis.dk/Default.asp?ID=296

Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
Check http://www.kortal.dk and have a look at Denmark from above!
- Videresendt af Peter Møller/Kampsax - 01-08-2002 08:55 -
   

Brian_VanDrut  

[EMAIL PROTECTED]   Til:[EMAIL PROTECTED] 

 cc:   

31-07-2002   Vedr.:  MI-L selecting blank records? 

17:44  

   

   




Hello all!

Is there any way to select blank records within a column through the SQL
select?

Brian Van Druten
Forestry Technician
Alligator River NWR
Manteo, NC


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





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

RE: MI-L SQL

[PEM]

Do remember to set the right projection before selecting the records with
SQL:

1. Open the MapBasic window
2. Enter this followed by a Enter: Set CoordSys Table 
 is the name of your table with the correct projection
3. Do the SQL select.

HTH,
Peter

Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
Kampsax A/S - GIS Software & Solutions
Rugaardsvej 55, 5000 Odense, DK
tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
mailto:[EMAIL PROTECTED]
www.kampsax-gis.dk and www.kampsax.dk
Authorized MapInfo Partner & Distributor in Denmark and Norway.

Se mere om Dansk MapInfo Brugerkonference på 
http://www.kampsax-gis.dk/Default.asp?ID=296

Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
Check http://www.kortal.dk and have a look at Denmark from above!
- Videresendt af Peter Møller/Kampsax - 01-08-2002 08:52 -
   
  
Andrew Tracey  
  
 cc: 
  
   Vedr.:  MI-L SQL
  
31-07-2002 17:49   
  
   
  
   
  



Dear All

I am producing a query that will give me all of the eastings and northings
for the points within a table. I can't get the results to show in metres, I
only get them in degrees, does anyone have any ideas.

Thanks

Andrew Tracey
Development Services Department
South Tyneside M.B.C.
Town Hall
Westoe Road
South Shields
Tyne & Wear
NE33 2RL

0191-4271717 Ext. 7561
E-Mail : [EMAIL PROTECTED]





**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
your system manager.

South Tyneside Metropolitan Borough Council
www.s-tyneside-mbc.gov.uk
**
stmbc-ms-disclaim

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





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

RE: RE: MI-L MB: Fastedit on?

[PEM]

Hi Tim,

You are right. There seems to be something rotten here. The Commit
statement doesn't disable the
fastedit mode. If you try editing the table again after saving it, the
edits are still made immediately.

I would consider as a bug, not a WAD, but of course I have before been
proven wrong in these things.
But anyway if this is a WAD the help file should be updated and state that
the only way to turn of the
fastedit mode is by using the Set Table ... FastEdit Off or closing the
table.

"Caution: While a table is open in FastEdit mode, other network users
cannot open that table."

This statement here from the MapBasic help file isn't entirely true either.
It isn't until there has been
made some changes to the table, that the table cannot be accessed by other
users.

Peter

Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
Kampsax A/S - GIS Software & Solutions
Rugaardsvej 55, 5000 Odense, DK
tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
mailto:[EMAIL PROTECTED]
www.kampsax-gis.dk and www.kampsax.dk
Authorized MapInfo Partner & Distributor in Denmark and Norway.

Se mere om Dansk MapInfo Brugerkonference på 
http://www.kampsax-gis.dk/Default.asp?ID=296

Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
Check http://www.kortal.dk and have a look at Denmark from above!
- Videresendt af Peter Møller/Kampsax - 01-08-2002 08:46 -
   
 
"Tim.Nuteson"  
 
<[EMAIL PROTECTED]>  
 
  cc:  
 
31-07-2002Vedr.:  RE: MI-L MB: Fastedit on?
 
18:22  
 
   
 
   
 



A quick test in the Mapbasic window using TableInfo(tab, 10), which reports
true/false, indicates that committing/saving a table has no effect on its
Fastedit status.  Here's a test:

1. open table mytable
2. MB Window:  note TableInfo(mytable, 10)  <-reports F
3. MB Window:  set table mytable fastedit on
4. MB Window:  note TableInfo(mytable, 10)  <-now reports T
5. do some edits, Save Table button becomes enabled
6. save the table
7. MB Window:  note TableInfo(mytable, 10)  <-still reports T

This isn't really a problem, but more of an annoyance that turned into a
curiosity.  I have an application that uses Fastedit, and my users want to
know why their Save Table button is lit if edits are supposedly being
immediately saved.  Maybe someone from MI can satisfy my curiosity and move
this back to annoyance status.

Tim Nuteson
Target Corporation



-Original Message-
From: Scott McVicar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?


"After you have completed all edits to be made in FastEdit
mode, issue a Commit statement or a Rollback statement. By issuing a Commit
or Rollback statement, you reset the file so that other network users can
access it."

Guess I should have read the MapInfo help a little more carefully...

-Original Message-
From: Stokes, Jonathan (J) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 11:08 AM
To: 'Evan MacDougall'; [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?


>From the entry on the "set table" statement in the mapbasic 6.5 manual

HTH

Jon.

Setting FastEdit Mode

Ordinarily, whenever a table is edited (either by the user or by a MapBasic
application), MapInfo does not immediately write the edit to the affected
table. Instead, MapInfo stores information about the edit to a temporary
file known as a transaction file. By writing to a transaction file instead
of writing directly to a table, MapInfo gives the user the opportunity to
later discard the edits (e.g. by choosing File > Revert).
If you use the Set Table statement to set FastEdit mode to On, MapInfo
writes edit information directly to the table, instead of performing the
intermediate step of writing the edit information to a transaction file.
Turning on FastEdit mode can make subsequent editing operations
substantially faster.

While FastEdit mode is on, table edits take effect immediately, even if you
do not issue a Commit statement. Use FastEdit 

RE: MI-L selecting blank records?

[JAL]

>>select blank records within a column ?

Select * from MYTABLE
Where not MYCOLUMNNAME into Selection
Browse * From Selection


Jakob 

**
Jakob Lanstorp  [EMAIL PROTECTED]
Developer 
Kampsax A/S - GSLhttp://www.kampsax.dk
Authorized MapInfo Partner & Distributor in Denmark and Norway
Address: Rugaardsvej 55, DK-5000 Odense C, Denmark
Telephone: +45 6313-5000   Facsimile +45 6313-5090
**
Visit http://www.kortal.dk and see Denmark from above!


- Videresendt af Jakob Lanstorp/Kampsax - 01-08-2002 08:30 -



[EMAIL PROTECTED]
31-07-2002 17:44

 
Til:[EMAIL PROTECTED]
cc: 
Vedr.:  MI-L selecting blank records?

Hello all!

Is there any way to select blank records within a column through the SQL
select?

Brian Van Druten
Forestry Technician
Alligator River NWR
Manteo, NC


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

MI-L custom symbol......

[Chris Loty]

I have a square that is 100m X 100m that i have created as a custom symbol.
Couple of questions:
I know there is a square symbol in Mapinfo already but i can only choose a
font to size 48. I need the above size.
Once i've saved it as a bitmap what are my next steps i.e do i crop it in
photoshop and if so what size, dpi e.t.c and when i paste the bmp to the
CUSTSYMB directory do i give it a number like the rest of the
bitmaps...

thanks again

Chris Loty
Wind Business Project Officer
Sustainable Energy Development Authority
(w) 9249 6192   (f) 9299 1519 
http://www.seda.nsw.gov.au

 This message is intended for the addressee named and may contain
confidential information. If you are not the intended recipient, please
delete it and notify the sender. Views expressed in this message are those
of the individual sender, and are not necessarily the views of SEDA.
The sender cannot guarantee that this email or any attachment to it is free
of computer viruses or other conditions which may damage or interfere with
data, hardware or software with which it might be used. It is sent on the
strict condition that the user carries out and relies on its own procedures
for ensuring that its use will not interfere with the recipient's systems
and the recipient assumes all risk of use and absolves the sender of all
responsibility for any consequence of its use.



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

MI-L MB getting file attributes

[Doug Pease]

HI,
 
Does any one have a function (in MapBasic) to get file attributes... creation date, 
last modified, etc..
 
Ive been trying to create my own using the API call CreateFile but because Im not 
aufait with API calls I just cant seem to make it work.  Its probable just a simple 
little thing Im overlooking but I just cant see it.
 
Any help appreciated. Thanks 
 
 
Doug Pease
GISO
Livingstone Shire Council
PO Box 600
Yeppoon 4703
Qld Australia
 
Ph07 49399957
Fax   07 49393290
 

RE: MI-L MapBasic DEF - THANKS.

[Simmonds, Ashley (PTB)]

thanks, got it now.

ash

-Original Message-
From: Simmonds, Ashley (PTB) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 August 2002 2:25 PM
To: 'Mapinfo List (E-mail)'
Subject: MI-L MapBasic DEF


hiya all,
 
don't know if this is against any particular copyright thing or just not
good manners, but would i be able to request a copy of this MAPBASIC.DEF
file?
 
my department won't get MapBasic for me, so all my custom and integrated
mapping stuff is done by trial and error, mostly through looking at the
examples on this list.  However i keep coming up against things like
"TableInfo(TableName, TAB_INFO_NROWS)". it's only through trial and lots of
error that I find that TAB_INFO_NROWS just means "8".  it's really
frustrating seeing all these great helpy things and not being able to really
use them easily.
 
so if anyone could help it'd be much appreciated.
 
gramercy
 
ash


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

MI-L MapBasic DEF

[Simmonds, Ashley (PTB)]

hiya all,
 
don't know if this is against any particular copyright thing or just not
good manners, but would i be able to request a copy of this MAPBASIC.DEF
file?
 
my department won't get MapBasic for me, so all my custom and integrated
mapping stuff is done by trial and error, mostly through looking at the
examples on this list.  However i keep coming up against things like
"TableInfo(TableName, TAB_INFO_NROWS)". it's only through trial and lots of
error that I find that TAB_INFO_NROWS just means "8".  it's really
frustrating seeing all these great helpy things and not being able to really
use them easily.
 
so if anyone could help it'd be much appreciated.
 
gramercy
 
ash



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

MI-L Selection Order

[Simmonds, Ashley (PTB)]

hey guys,
 
does anyone know if there's a way to have the records you have selected list
in the browser in the order in which you selected them?
 
eg.  I select a dozen points in a particular order, Browse * from Selection,
and it shows those records in MAPINFO record order, but i want them in order
of selection.
 
gramercy
 
ash



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

Re: MI-L MB: Fastedit on?

[Philip Waight]

With fastedit off, when you edit a table in any way, a TDA, TIN and TMA
transaction file set is created (for dat, ind, map?).

With fastedit on, an empty TDA is created for an INFO tool or interactive
object edit. If an update is performed, a TDA with similar header to DAT is
created (containing column names). TIN and TMA are not created. Also the
TAB_INFO_EDITED, tableinfo status is set to TRUE.

So the SAVE button enabling and TDA creation is possibly a small bug, or
(being generous) "works as designed" and the TDA is there to tell another MI
that an edit has happened  and the SAVE enabling is there to tell the user
that they have "touched" the file in some way ?!  The ID file seems to be
opened exclusively when fastedit is on (not usually the case). SAVE deletes
the TDA file.

Best performance on updates/edits ==> progressbars off, fastedit on, undo
off

Phil.

- Original Message -
From: "Tim.Nuteson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 1:57 AM
Subject: MI-L MB: Fastedit on?


> I have "Fastedit On" set for a table, yet as soon as edits are made the
Save
> button on the toolbar lights up.  When I click on the Save button, the
> FastEdited table is listed as one that needs saving.  If I instead just
> close the table WITHOUT saving it, I am not prompted to save it.
>
> 1.  If Fastedit is ON, why does MI Pro think the table has unsaved edits
> (i.e. the Save button lights)?
> 2.  If the Save button is lit, why am I allowed to close the table without
> being prompted to save it?
>
> Can anyone explain this?  Using MI Pro 6.5.
>
> Thanks
>
> Tim Nuteson
> Target Corporation
>
>


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

RE: MI-L querying numbers to right of decimal place

[Jacques Paris]

If there is a decimal "point" in all the lines then try

Select * from ur_tab where len(str$(ur_tab.ut_col)) -
instr(1,str$(ur_tab.ur.col,".")=2 into sel

If there are cases without decimal point, then add an extra condition:

Select * from ur_tab where instr(1,str$(ur_tab.ur_col,".")>0 and
len(str$(ur_tab.ut_col)) - instr(1,str$(ur_tab.ur_col,".")=2 into sel

Jacques Paris
e-mail  [EMAIL PROTECTED]
MapBasic-MapInfo support  http://www.paris-pc-gis.com

-Original Message-
From: Gerasimtchouk, Renee [mailto:[EMAIL PROTECTED]]
Sent: July 31, 2002 16:53
To: '[EMAIL PROTECTED]'
Subject: MI-L querying numbers to right of decimal place


I have a column with numbers and decimal places such as 13.0 and I want a
query that shows only the records that have two numbers to the right of the
decimal place. I can't get the syntax quite right. Any suggestions?

Thank you,

Renee


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


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

MI-L querying numbers to right of decimal place

[Gerasimtchouk, Renee]

I have a column with numbers and decimal places such as 13.0 and I want a
query that shows only the records that have two numbers to the right of the
decimal place. I can't get the syntax quite right. Any suggestions?

Thank you,

Renee


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

MI-L MB - Updating Symbols revisited

[Ron Halliday (Portolan Geomatics)]

Hello listers, I sent this message out yesterday but didn't get any
solutions:

---
Hello all, I hope someone out there can help me, I'm having a small
problem using MapBasic 4.0 to update a table with point objects. I want
to change their style but regardless of what symbol number I choose, I
either get an invisible object (because the number is less than 31 or
32, whatever) or a solid square. And when I double click the object and
go into the font dialog, the font name, colour, size, etc are all fine,
but when I click the symbol chooser, the entire font is filled with
these squareswhen I pick a different symbol font and return to my
original, the proper symbols return...bizarre! Has anyone encountered
this before? I've done it on two different computers, Win 98 and 2000,
and with MI 5 and MI 6! Here's a snippet of code, assuming everything's
declared, etc. because I get no errors:

For y = 1 to TableInfo(MyTable,TAB_INFO_NROWS)
Select * from MyTable where RowID = y into CurObjTab
CurObj = CurObjTab.obj
S_Style = MakeFontSymbol(65,RED,24,"WingDings,32,0)
Alter Object CurObj Info OBJ_INFO_SYMBOL, S_Style
Update MyTable Set obj = CurObj where RowID = y
Next

I thinned out the code a little because I'm also updating lines and
regions too but those aren't causing me any problems!
---

One thing that I just realized today is that all I need to do to get the
symbols to show up correctly is grab the Symbol Font picker, scroll up
and down a little bit, return to my original font and voila! the correct
symbol suddenly appears! You can see how frustrating this is when my
program is obviously working...if anyone out there has some spare time I
could really use some help here!

TIA,
Ron

Ron Halliday, Cartographer
Portolan Geomatics
Calgary, AB, Canada


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

Re: MI-L MapInfo Scale

[Simon Roy]

Anirban,

   Do Smallworld imports mid-mif files?

Simon Roy
GIS Specialist
Carto-Média, Environnement Illimité
Montreal
tel.:514-849-7281
Fax.:514-849-6770
Email : [EMAIL PROTECTED]
- Original Message -
From: "Anirban" <[EMAIL PROTECTED]>
To: "'Mapinfo List (E-mail)'" <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 2:13 AM
Subject: MI-L MapInfo Scale


> Dear Listers,
>
> This may be a very simple question but to me it is not clear.
>
> How is Map Scale used in Mapinfo ? the question may be spit up into.
>
> 1. How to identify the Scale of a Map (not the display scale but the scale
> in which the map is created)
>
> 2. How to set a map scale for a new map ? say i want to make a map from a
> raster which is at 1:1 or 1:25000 scale how do i make such a map and
get
> the scale i want ?
>
> 3. For example Smallworld has fixed map scales(creation map scales) and
> display scales(similar to Mapino which changes on zooming in or out) . is
> there any equivalent in Mapinfo ?
>
> 4. Say i am importing a Mapinfo map to Smallworld. The converter asks for
> the map scale for input. I can find the map scale from smallworld easily.
> Now how to identify the correct scale for the map in MI and take it as a
> input for my conversion?
>
> Any information and dicussions would be appreciated.
>
> TIA,
>
> Anirban
>
>
> -
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> Message number: 2275
>
>
>


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

MI-L Thanks

[Brian_VanDruten]

Thanks for all the answers with regards to selecting blank records.

Brian Van Druten
Forestry Technician
Alligator River NWR
Manteo, NC


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

RE: MI-L MB: Fastedit on?

[Tim.Nuteson]

A quick test in the Mapbasic window using TableInfo(tab, 10), which reports
true/false, indicates that committing/saving a table has no effect on its
Fastedit status.  Here's a test:

1. open table mytable
2. MB Window:  note TableInfo(mytable, 10)  <-reports F
3. MB Window:  set table mytable fastedit on
4. MB Window:  note TableInfo(mytable, 10)  <-now reports T
5. do some edits, Save Table button becomes enabled
6. save the table
7. MB Window:  note TableInfo(mytable, 10)  <-still reports T

This isn't really a problem, but more of an annoyance that turned into a
curiosity.  I have an application that uses Fastedit, and my users want to
know why their Save Table button is lit if edits are supposedly being
immediately saved.  Maybe someone from MI can satisfy my curiosity and move
this back to annoyance status.

Tim Nuteson
Target Corporation



-Original Message-
From: Scott McVicar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?


"After you have completed all edits to be made in FastEdit
mode, issue a Commit statement or a Rollback statement. By issuing a Commit
or Rollback statement, you reset the file so that other network users can
access it."

Guess I should have read the MapInfo help a little more carefully...

-Original Message-
From: Stokes, Jonathan (J) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 11:08 AM
To: 'Evan MacDougall'; [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?


>From the entry on the "set table" statement in the mapbasic 6.5 manual

HTH

Jon.

Setting FastEdit Mode 

Ordinarily, whenever a table is edited (either by the user or by a MapBasic
application), MapInfo does not immediately write the edit to the affected
table. Instead, MapInfo stores information about the edit to a temporary
file known as a transaction file. By writing to a transaction file instead
of writing directly to a table, MapInfo gives the user the opportunity to
later discard the edits (e.g. by choosing File > Revert). 
If you use the Set Table statement to set FastEdit mode to On, MapInfo
writes edit information directly to the table, instead of performing the
intermediate step of writing the edit information to a transaction file.
Turning on FastEdit mode can make subsequent editing operations
substantially faster. 

While FastEdit mode is on, table edits take effect immediately, even if you
do not issue a Commit statement. Use FastEdit mode with caution; there is no
opportunity to discard edits by choosing File > Close or File > Revert. 
You can only turn FastEdit mode on for normal, base tables; you cannot turn
on FastEdit for a temporary, query table such as Query1. You cannot turn on
FastEdit mode for a table that already has unsaved changes. You cannot turn
on FastEdit mode for a linked table. 

Caution: While a table is open in FastEdit mode, other network users cannot
open that table. After you have completed all edits to be made in FastEdit
mode, issue a Commit statement or a Rollback statement. By issuing a Commit
or Rollback statement, you reset the file so that other network users can
access it. 

> -Original Message-
> From: Evan MacDougall [SMTP:[EMAIL PROTECTED]]
> Sent: 31 July 2002 16:00
> To:   [EMAIL PROTECTED]
> Subject:  RE: MI-L MB: Fastedit on?
> 
> What is fastedit and what have i never heard of it before? (i'm using
> Mi-pro v6.5)  how do you enable fastedit?  i suddenly feel ignorant.  i
> hate when that happens
> 
> -Evan MacDougall ([EMAIL PROTECTED])
> GIS Supervisor
> DPSI (formerly ACE USA Flood Services)
> (310)342-3600 / (800)736-3109 - ext. 3681
> 
> 
> -Original Message-
> From: Scott McVicar [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 7:51 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
> 
> 
> 
> Perhaps one of our friends on the list from MapInfo could fill us in?
> I have also wondered about this and would greatly appreciate some
> clarification.
> 
> Thanks,
> Scott 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 10:00 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
> 
> 
> Hi Tim,
> 
> When you set fastedit on, the only reason I can think of why MapInfo
> enables the Save Table button, is to disable
> the FastEdit again.
> 
> When you save the table the FastEdit mode is turned off. Actually there
> is
> no edit to be saved because they have
> allready been saved to the table, this is what the FastEdit mode
> enables.
> 
> So when you push the Save Table and "save" the table with the FastEdit
> mode
> turned on, the only thing that actually
> happens is that the FastEdit Mode is turned off for this table. Closing
> the
> table without "saving" it doesn't result in lost
> data, because the changes have allready be made in the table.
> 
> I'm not quite sure whether this does explaine the behaviour fully, but
> it
> migh

MI-L SQL

[Andrew Tracey]

Dear All

I am producing a query that will give me all of the eastings and northings
for the points within a table. I can't get the results to show in metres, I
only get them in degrees, does anyone have any ideas.

Thanks

Andrew Tracey
Development Services Department
South Tyneside M.B.C.
Town Hall
Westoe Road
South Shields
Tyne & Wear
NE33 2RL

0191-4271717 Ext. 7561
E-Mail : [EMAIL PROTECTED]
 




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
your system manager.

South Tyneside Metropolitan Borough Council
www.s-tyneside-mbc.gov.uk
**
stmbc-ms-disclaim

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

MI-L selecting blank records?

[Brian_VanDruten]

Hello all!

Is there any way to select blank records within a column through the SQL
select?

Brian Van Druten
Forestry Technician
Alligator River NWR
Manteo, NC


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

RE: MI-L MB: Fastedit on?

[Scott McVicar]

"After you have completed all edits to be made in FastEdit
mode, issue a Commit statement or a Rollback statement. By issuing a Commit
or Rollback statement, you reset the file so that other network users can
access it."

Guess I should have read the MapInfo help a little more carefully...

-Original Message-
From: Stokes, Jonathan (J) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 11:08 AM
To: 'Evan MacDougall'; [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?


>From the entry on the "set table" statement in the mapbasic 6.5 manual

HTH

Jon.

Setting FastEdit Mode 

Ordinarily, whenever a table is edited (either by the user or by a MapBasic
application), MapInfo does not immediately write the edit to the affected
table. Instead, MapInfo stores information about the edit to a temporary
file known as a transaction file. By writing to a transaction file instead
of writing directly to a table, MapInfo gives the user the opportunity to
later discard the edits (e.g. by choosing File > Revert). 
If you use the Set Table statement to set FastEdit mode to On, MapInfo
writes edit information directly to the table, instead of performing the
intermediate step of writing the edit information to a transaction file.
Turning on FastEdit mode can make subsequent editing operations
substantially faster. 

While FastEdit mode is on, table edits take effect immediately, even if you
do not issue a Commit statement. Use FastEdit mode with caution; there is no
opportunity to discard edits by choosing File > Close or File > Revert. 
You can only turn FastEdit mode on for normal, base tables; you cannot turn
on FastEdit for a temporary, query table such as Query1. You cannot turn on
FastEdit mode for a table that already has unsaved changes. You cannot turn
on FastEdit mode for a linked table. 

Caution: While a table is open in FastEdit mode, other network users cannot
open that table. After you have completed all edits to be made in FastEdit
mode, issue a Commit statement or a Rollback statement. By issuing a Commit
or Rollback statement, you reset the file so that other network users can
access it. 

> -Original Message-
> From: Evan MacDougall [SMTP:[EMAIL PROTECTED]]
> Sent: 31 July 2002 16:00
> To:   [EMAIL PROTECTED]
> Subject:  RE: MI-L MB: Fastedit on?
> 
> What is fastedit and what have i never heard of it before? (i'm using
> Mi-pro v6.5)  how do you enable fastedit?  i suddenly feel ignorant.  i
> hate when that happens
> 
> -Evan MacDougall ([EMAIL PROTECTED])
> GIS Supervisor
> DPSI (formerly ACE USA Flood Services)
> (310)342-3600 / (800)736-3109 - ext. 3681
> 
> 
> -Original Message-
> From: Scott McVicar [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 7:51 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
> 
> 
> 
> Perhaps one of our friends on the list from MapInfo could fill us in?
> I have also wondered about this and would greatly appreciate some
> clarification.
> 
> Thanks,
> Scott 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 10:00 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
> 
> 
> Hi Tim,
> 
> When you set fastedit on, the only reason I can think of why MapInfo
> enables the Save Table button, is to disable
> the FastEdit again.
> 
> When you save the table the FastEdit mode is turned off. Actually there
> is
> no edit to be saved because they have
> allready been saved to the table, this is what the FastEdit mode
> enables.
> 
> So when you push the Save Table and "save" the table with the FastEdit
> mode
> turned on, the only thing that actually
> happens is that the FastEdit Mode is turned off for this table. Closing
> the
> table without "saving" it doesn't result in lost
> data, because the changes have allready be made in the table.
> 
> I'm not quite sure whether this does explaine the behaviour fully, but
> it
> might give you a better understanding of the
> FastEdit mode.
> 
> Peter
> 
> 
> 
> Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
> Kampsax A/S - GIS Software & Solutions
> Rugaardsvej 55, 5000 Odense, DK
> tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
> mailto:[EMAIL PROTECTED]
> www.kampsax-gis.dk and www.kampsax.dk
> Authorized MapInfo Partner & Distributor in Denmark and Norway.
> 
> 
> 
> Se mere om Dansk MapInfo Brugerkonference på
> http://www.kampsax-gis.dk/Default.asp?ID=296
> 
> Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
> Check http://www.kortal.dk and have a look at Denmark from above!
> - Videresendt af Peter Møller/Kampsax - 31-07-2002 15:53 -
>  
> 
> "Tim.Nuteson"
> 
>  [EMAIL PROTECTED] 

Re: MI-L MB: Fastedit on?

[Uffe Kousgaard]

It speeds up things a lot. Not so much when doing on-screen editing, but
when running the update command there is a significant difference.

Drawing maps is also slower, when the transaction file gets big.

But all in all, you need some big datasets to see the difference. A few
100,000 records should be enough.

Regards
Uffe

- Original Message -
From: "Niemiec, Neal" <[EMAIL PROTECTED]>
To: "'Evan MacDougall'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 5:10 PM
Subject: RE: MI-L MB: Fastedit on?


Through normal editing, Mapinfo creates a transaction file for the table
being edited. This allows the user the REVERT the table if the user
wishes
to get rid of the changes. By turning fastedit on, you make the changes
directly to the table and reverting changes cannot be done, however, I
guess
the speed of the changes is increased. I have never tried using it, but
if
anyone can give light to the possible increase in speed I would like to
hear
it. It can only be done in the Mapbasic window or script.

NEAL

> -Original Message-
> From: Evan MacDougall [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 9:00 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
>
> What is fastedit and what have i never heard of it before? (i'm using
> Mi-pro v6.5)  how do you enable fastedit?  i suddenly feel ignorant.
i
> hate when that happens
>
> -Evan MacDougall ([EMAIL PROTECTED])
> GIS Supervisor
> DPSI (formerly ACE USA Flood Services)
> (310)342-3600 / (800)736-3109 - ext. 3681
>
>
> -Original Message-
> From: Scott McVicar [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 7:51 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
>
>
>
> Perhaps one of our friends on the list from MapInfo could fill us in?
> I have also wondered about this and would greatly appreciate some
> clarification.
>
> Thanks,
> Scott
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 10:00 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
>
>
> Hi Tim,
>
> When you set fastedit on, the only reason I can think of why MapInfo
> enables the Save Table button, is to disable
> the FastEdit again.
>
> When you save the table the FastEdit mode is turned off. Actually
there
> is
> no edit to be saved because they have
> allready been saved to the table, this is what the FastEdit mode
> enables.
>
> So when you push the Save Table and "save" the table with the FastEdit
> mode
> turned on, the only thing that actually
> happens is that the FastEdit Mode is turned off for this table.
Closing
> the
> table without "saving" it doesn't result in lost
> data, because the changes have allready be made in the table.
>
> I'm not quite sure whether this does explaine the behaviour fully, but
> it
> might give you a better understanding of the
> FastEdit mode.
>
> Peter
> --
--
> 
> 
> Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
> Kampsax A/S - GIS Software & Solutions
> Rugaardsvej 55, 5000 Odense, DK
> tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
> mailto:[EMAIL PROTECTED]
> www.kampsax-gis.dk and www.kampsax.dk
> Authorized MapInfo Partner & Distributor in Denmark and Norway.
> --
--
> 
> 
> Se mere om Dansk MapInfo Brugerkonference på
> http://www.kampsax-gis.dk/Default.asp?ID=296
>
> Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
> Check http://www.kortal.dk and have a look at Denmark from above!
> - Videresendt af Peter Møller/Kampsax - 31-07-2002 15:53 -
>
>
> "Tim.Nuteson"
>
>  [EMAIL PROTECTED]
> arget.com>cc:
>
>   Vedr.:  MI-L MB: Fastedit
on?
>
> 30-07-2002
>
> 17:57
>
>
>
>
>
>
>
>
> I have "Fastedit On" set for a table, yet as soon as edits are made
the
> Save
> button on the toolbar lights up.  When I click on the Save button, the
> FastEdited table is listed as one that needs saving.  If I instead
just
> close the table WITHOUT saving it, I am not prompted to save it.
>
> 1.  If Fastedit is ON, why does MI Pro think the table has unsaved
edits
> (i.e. the Save button lights)?
> 2.  If the Save button is lit, why am I allowed to close the table
> without
> being prompted to save it?
>
> Can anyone explain this?  Using MI Pro 6.5.
>
> Thanks
>
> Tim Nuteson
> Target Corporation
>
>
>
>
>
> -
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail:
[EMAIL PROTECTED]
> Message number: 2282
>
> --

RE: MI-L MB: Fastedit on?

[Scott McVicar]

I should have added...

It is my understanding that short of closing the table (obviously) or
issuing the FastEdit Off command,
the only other way that FastEdit On would become disabled was if an Alter
Table command was issued.

If Committing (saving) the table does indeed disable FastEdit On I will have
to look into some of my programs...

For those of you unfamiliar with FastEdit, look into the Set Table command
in your MapBasic help.

Scott

-Original Message-
From: Evan MacDougall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 11:00 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?


What is fastedit and what have i never heard of it before? (i'm using
Mi-pro v6.5)  how do you enable fastedit?  i suddenly feel ignorant.  i
hate when that happens

-Evan MacDougall ([EMAIL PROTECTED])
GIS Supervisor
DPSI (formerly ACE USA Flood Services)
(310)342-3600 / (800)736-3109 - ext. 3681


-Original Message-
From: Scott McVicar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 7:51 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?



Perhaps one of our friends on the list from MapInfo could fill us in?
I have also wondered about this and would greatly appreciate some
clarification.

Thanks,
Scott 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:00 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?


Hi Tim,

When you set fastedit on, the only reason I can think of why MapInfo
enables the Save Table button, is to disable
the FastEdit again.

When you save the table the FastEdit mode is turned off. Actually there
is
no edit to be saved because they have
allready been saved to the table, this is what the FastEdit mode
enables.

So when you push the Save Table and "save" the table with the FastEdit
mode
turned on, the only thing that actually
happens is that the FastEdit Mode is turned off for this table. Closing
the
table without "saving" it doesn't result in lost
data, because the changes have allready be made in the table.

I'm not quite sure whether this does explaine the behaviour fully, but
it
might give you a better understanding of the
FastEdit mode.

Peter



Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
Kampsax A/S - GIS Software & Solutions
Rugaardsvej 55, 5000 Odense, DK
tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
mailto:[EMAIL PROTECTED]
www.kampsax-gis.dk and www.kampsax.dk
Authorized MapInfo Partner & Distributor in Denmark and Norway.



Se mere om Dansk MapInfo Brugerkonference på
http://www.kampsax-gis.dk/Default.asp?ID=296

Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
Check http://www.kortal.dk and have a look at Denmark from above!
- Videresendt af Peter Møller/Kampsax - 31-07-2002 15:53 -
 

"Tim.Nuteson"

cc:

  Vedr.:  MI-L MB: Fastedit on?

30-07-2002

17:57

 

 




I have "Fastedit On" set for a table, yet as soon as edits are made the
Save
button on the toolbar lights up.  When I click on the Save button, the
FastEdited table is listed as one that needs saving.  If I instead just
close the table WITHOUT saving it, I am not prompted to save it.

1.  If Fastedit is ON, why does MI Pro think the table has unsaved edits
(i.e. the Save button lights)?
2.  If the Save button is lit, why am I allowed to close the table
without
being prompted to save it?

Can anyone explain this?  Using MI Pro 6.5.

Thanks

Tim Nuteson
Target Corporation





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

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

RE: MI-L MB: Fastedit on?

[Niemiec, Neal]

Through normal editing, Mapinfo creates a transaction file for the table
being edited. This allows the user the REVERT the table if the user wishes
to get rid of the changes. By turning fastedit on, you make the changes
directly to the table and reverting changes cannot be done, however, I guess
the speed of the changes is increased. I have never tried using it, but if
anyone can give light to the possible increase in speed I would like to hear
it. It can only be done in the Mapbasic window or script.

NEAL

> -Original Message-
> From: Evan MacDougall [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 9:00 AM
> To:   [EMAIL PROTECTED]
> Subject:  RE: MI-L MB: Fastedit on?
> 
> What is fastedit and what have i never heard of it before? (i'm using
> Mi-pro v6.5)  how do you enable fastedit?  i suddenly feel ignorant.  i
> hate when that happens
> 
> -Evan MacDougall ([EMAIL PROTECTED])
> GIS Supervisor
> DPSI (formerly ACE USA Flood Services)
> (310)342-3600 / (800)736-3109 - ext. 3681
> 
> 
> -Original Message-
> From: Scott McVicar [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 7:51 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
> 
> 
> 
> Perhaps one of our friends on the list from MapInfo could fill us in?
> I have also wondered about this and would greatly appreciate some
> clarification.
> 
> Thanks,
> Scott 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 10:00 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
> 
> 
> Hi Tim,
> 
> When you set fastedit on, the only reason I can think of why MapInfo
> enables the Save Table button, is to disable
> the FastEdit again.
> 
> When you save the table the FastEdit mode is turned off. Actually there
> is
> no edit to be saved because they have
> allready been saved to the table, this is what the FastEdit mode
> enables.
> 
> So when you push the Save Table and "save" the table with the FastEdit
> mode
> turned on, the only thing that actually
> happens is that the FastEdit Mode is turned off for this table. Closing
> the
> table without "saving" it doesn't result in lost
> data, because the changes have allready be made in the table.
> 
> I'm not quite sure whether this does explaine the behaviour fully, but
> it
> might give you a better understanding of the
> FastEdit mode.
> 
> Peter
> 
> 
> 
> Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
> Kampsax A/S - GIS Software & Solutions
> Rugaardsvej 55, 5000 Odense, DK
> tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
> mailto:[EMAIL PROTECTED]
> www.kampsax-gis.dk and www.kampsax.dk
> Authorized MapInfo Partner & Distributor in Denmark and Norway.
> 
> 
> 
> Se mere om Dansk MapInfo Brugerkonference på
> http://www.kampsax-gis.dk/Default.asp?ID=296
> 
> Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
> Check http://www.kortal.dk and have a look at Denmark from above!
> - Videresendt af Peter Møller/Kampsax - 31-07-2002 15:53 -
>  
> 
> "Tim.Nuteson"
> 
>  [EMAIL PROTECTED] 
> arget.com>cc:
> 
>   Vedr.:  MI-L MB: Fastedit on?
> 
> 30-07-2002
> 
> 17:57
> 
>  
> 
>  
> 
> 
> 
> 
> I have "Fastedit On" set for a table, yet as soon as edits are made the
> Save
> button on the toolbar lights up.  When I click on the Save button, the
> FastEdited table is listed as one that needs saving.  If I instead just
> close the table WITHOUT saving it, I am not prompted to save it.
> 
> 1.  If Fastedit is ON, why does MI Pro think the table has unsaved edits
> (i.e. the Save button lights)?
> 2.  If the Save button is lit, why am I allowed to close the table
> without
> being prompted to save it?
> 
> Can anyone explain this?  Using MI Pro 6.5.
> 
> Thanks
> 
> Tim Nuteson
> Target Corporation
> 
> 
> 
> 
> 
> -
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> Message number: 2282
> 
> -
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> Message number: 2284

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

RE: MI-L MB: Fastedit on?

[Stokes, Jonathan (J)]

>From the entry on the "set table" statement in the mapbasic 6.5 manual

HTH

Jon.

Setting FastEdit Mode 

Ordinarily, whenever a table is edited (either by the user or by a MapBasic
application), MapInfo does not immediately write the edit to the affected
table. Instead, MapInfo stores information about the edit to a temporary
file known as a transaction file. By writing to a transaction file instead
of writing directly to a table, MapInfo gives the user the opportunity to
later discard the edits (e.g. by choosing File > Revert). 
If you use the Set Table statement to set FastEdit mode to On, MapInfo
writes edit information directly to the table, instead of performing the
intermediate step of writing the edit information to a transaction file.
Turning on FastEdit mode can make subsequent editing operations
substantially faster. 

While FastEdit mode is on, table edits take effect immediately, even if you
do not issue a Commit statement. Use FastEdit mode with caution; there is no
opportunity to discard edits by choosing File > Close or File > Revert. 
You can only turn FastEdit mode on for normal, base tables; you cannot turn
on FastEdit for a temporary, query table such as Query1. You cannot turn on
FastEdit mode for a table that already has unsaved changes. You cannot turn
on FastEdit mode for a linked table. 

Caution: While a table is open in FastEdit mode, other network users cannot
open that table. After you have completed all edits to be made in FastEdit
mode, issue a Commit statement or a Rollback statement. By issuing a Commit
or Rollback statement, you reset the file so that other network users can
access it. 

> -Original Message-
> From: Evan MacDougall [SMTP:[EMAIL PROTECTED]]
> Sent: 31 July 2002 16:00
> To:   [EMAIL PROTECTED]
> Subject:  RE: MI-L MB: Fastedit on?
> 
> What is fastedit and what have i never heard of it before? (i'm using
> Mi-pro v6.5)  how do you enable fastedit?  i suddenly feel ignorant.  i
> hate when that happens
> 
> -Evan MacDougall ([EMAIL PROTECTED])
> GIS Supervisor
> DPSI (formerly ACE USA Flood Services)
> (310)342-3600 / (800)736-3109 - ext. 3681
> 
> 
> -Original Message-
> From: Scott McVicar [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 7:51 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
> 
> 
> 
> Perhaps one of our friends on the list from MapInfo could fill us in?
> I have also wondered about this and would greatly appreciate some
> clarification.
> 
> Thanks,
> Scott 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 10:00 AM
> To: [EMAIL PROTECTED]
> Subject: RE: MI-L MB: Fastedit on?
> 
> 
> Hi Tim,
> 
> When you set fastedit on, the only reason I can think of why MapInfo
> enables the Save Table button, is to disable
> the FastEdit again.
> 
> When you save the table the FastEdit mode is turned off. Actually there
> is
> no edit to be saved because they have
> allready been saved to the table, this is what the FastEdit mode
> enables.
> 
> So when you push the Save Table and "save" the table with the FastEdit
> mode
> turned on, the only thing that actually
> happens is that the FastEdit Mode is turned off for this table. Closing
> the
> table without "saving" it doesn't result in lost
> data, because the changes have allready be made in the table.
> 
> I'm not quite sure whether this does explaine the behaviour fully, but
> it
> might give you a better understanding of the
> FastEdit mode.
> 
> Peter
> 
> 
> 
> Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
> Kampsax A/S - GIS Software & Solutions
> Rugaardsvej 55, 5000 Odense, DK
> tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
> mailto:[EMAIL PROTECTED]
> www.kampsax-gis.dk and www.kampsax.dk
> Authorized MapInfo Partner & Distributor in Denmark and Norway.
> 
> 
> 
> Se mere om Dansk MapInfo Brugerkonference på
> http://www.kampsax-gis.dk/Default.asp?ID=296
> 
> Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
> Check http://www.kortal.dk and have a look at Denmark from above!
> - Videresendt af Peter Møller/Kampsax - 31-07-2002 15:53 -
>  
> 
> "Tim.Nuteson"
> 
>  [EMAIL PROTECTED] 
> arget.com>cc:
> 
>   Vedr.:  MI-L MB: Fastedit on?
> 
> 30-07-2002
> 
> 17:57
> 
>  
> 
>  
> 
> 
> 
> 
> I have "Fastedit On" set for a table, yet as soon as edits are made the
> Save
> button on the toolbar lights up.  When I click on the Save button, the
> FastEdited table is listed as one that needs saving.  If I instead just
> close the table WITHOUT saving it, I am not

RE: MI-L MB: Fastedit on?

[Evan MacDougall]

What is fastedit and what have i never heard of it before? (i'm using
Mi-pro v6.5)  how do you enable fastedit?  i suddenly feel ignorant.  i
hate when that happens

-Evan MacDougall ([EMAIL PROTECTED])
GIS Supervisor
DPSI (formerly ACE USA Flood Services)
(310)342-3600 / (800)736-3109 - ext. 3681


-Original Message-
From: Scott McVicar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 7:51 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?



Perhaps one of our friends on the list from MapInfo could fill us in?
I have also wondered about this and would greatly appreciate some
clarification.

Thanks,
Scott 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:00 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?


Hi Tim,

When you set fastedit on, the only reason I can think of why MapInfo
enables the Save Table button, is to disable
the FastEdit again.

When you save the table the FastEdit mode is turned off. Actually there
is
no edit to be saved because they have
allready been saved to the table, this is what the FastEdit mode
enables.

So when you push the Save Table and "save" the table with the FastEdit
mode
turned on, the only thing that actually
happens is that the FastEdit Mode is turned off for this table. Closing
the
table without "saving" it doesn't result in lost
data, because the changes have allready be made in the table.

I'm not quite sure whether this does explaine the behaviour fully, but
it
might give you a better understanding of the
FastEdit mode.

Peter



Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
Kampsax A/S - GIS Software & Solutions
Rugaardsvej 55, 5000 Odense, DK
tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
mailto:[EMAIL PROTECTED]
www.kampsax-gis.dk and www.kampsax.dk
Authorized MapInfo Partner & Distributor in Denmark and Norway.



Se mere om Dansk MapInfo Brugerkonference på
http://www.kampsax-gis.dk/Default.asp?ID=296

Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
Check http://www.kortal.dk and have a look at Denmark from above!
- Videresendt af Peter Møller/Kampsax - 31-07-2002 15:53 -
 

"Tim.Nuteson"

cc:

  Vedr.:  MI-L MB: Fastedit on?

30-07-2002

17:57

 

 




I have "Fastedit On" set for a table, yet as soon as edits are made the
Save
button on the toolbar lights up.  When I click on the Save button, the
FastEdited table is listed as one that needs saving.  If I instead just
close the table WITHOUT saving it, I am not prompted to save it.

1.  If Fastedit is ON, why does MI Pro think the table has unsaved edits
(i.e. the Save button lights)?
2.  If the Save button is lit, why am I allowed to close the table
without
being prompted to save it?

Can anyone explain this?  Using MI Pro 6.5.

Thanks

Tim Nuteson
Target Corporation





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

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

RE: MI-L MB: Fastedit on?

[Scott McVicar]

Perhaps one of our friends on the list from MapInfo could fill us in?
I have also wondered about this and would greatly appreciate some
clarification.

Thanks,
Scott 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:00 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L MB: Fastedit on?


Hi Tim,

When you set fastedit on, the only reason I can think of why MapInfo
enables the Save Table button, is to disable
the FastEdit again.

When you save the table the FastEdit mode is turned off. Actually there is
no edit to be saved because they have
allready been saved to the table, this is what the FastEdit mode enables.

So when you push the Save Table and "save" the table with the FastEdit mode
turned on, the only thing that actually
happens is that the FastEdit Mode is turned off for this table. Closing the
table without "saving" it doesn't result in lost
data, because the changes have allready be made in the table.

I'm not quite sure whether this does explaine the behaviour fully, but it
might give you a better understanding of the
FastEdit mode.

Peter


Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
Kampsax A/S - GIS Software & Solutions
Rugaardsvej 55, 5000 Odense, DK
tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
mailto:[EMAIL PROTECTED]
www.kampsax-gis.dk and www.kampsax.dk
Authorized MapInfo Partner & Distributor in Denmark and Norway.


Se mere om Dansk MapInfo Brugerkonference på
http://www.kampsax-gis.dk/Default.asp?ID=296

Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
Check http://www.kortal.dk and have a look at Denmark from above!
- Videresendt af Peter Møller/Kampsax - 31-07-2002 15:53 -
 

"Tim.Nuteson"

cc:

  Vedr.:  MI-L MB: Fastedit on?

30-07-2002

17:57

 

 




I have "Fastedit On" set for a table, yet as soon as edits are made the
Save
button on the toolbar lights up.  When I click on the Save button, the
FastEdited table is listed as one that needs saving.  If I instead just
close the table WITHOUT saving it, I am not prompted to save it.

1.  If Fastedit is ON, why does MI Pro think the table has unsaved edits
(i.e. the Save button lights)?
2.  If the Save button is lit, why am I allowed to close the table without
being prompted to save it?

Can anyone explain this?  Using MI Pro 6.5.

Thanks

Tim Nuteson
Target Corporation





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

RE: MI-L MB: Fastedit on?

[PEM]

Hi Tim,

When you set fastedit on, the only reason I can think of why MapInfo
enables the Save Table button, is to disable
the FastEdit again.

When you save the table the FastEdit mode is turned off. Actually there is
no edit to be saved because they have
allready been saved to the table, this is what the FastEdit mode enables.

So when you push the Save Table and "save" the table with the FastEdit mode
turned on, the only thing that actually
happens is that the FastEdit Mode is turned off for this table. Closing the
table without "saving" it doesn't result in lost
data, because the changes have allready be made in the table.

I'm not quite sure whether this does explaine the behaviour fully, but it
might give you a better understanding of the
FastEdit mode.

Peter

Peter Horsbøll Møller, GIS Udviklingskonsulent / GIS-Developer
Kampsax A/S - GIS Software & Solutions
Rugaardsvej 55, 5000 Odense, DK
tel: +45 6313 5013,  dir:+45 6313 5008,  fax: +45 6313 5090
mailto:[EMAIL PROTECTED]
www.kampsax-gis.dk and www.kampsax.dk
Authorized MapInfo Partner & Distributor in Denmark and Norway.

Se mere om Dansk MapInfo Brugerkonference på 
http://www.kampsax-gis.dk/Default.asp?ID=296

Klik ind på http://www.kortal.dk og se det hele lidt fra oven!
Check http://www.kortal.dk and have a look at Denmark from above!
- Videresendt af Peter Møller/Kampsax - 31-07-2002 15:53 -
   
 
"Tim.Nuteson"  
 
cc:  
 
  Vedr.:  MI-L MB: Fastedit on?
 
30-07-2002 
 
17:57  
 
   
 
   
 



I have "Fastedit On" set for a table, yet as soon as edits are made the
Save
button on the toolbar lights up.  When I click on the Save button, the
FastEdited table is listed as one that needs saving.  If I instead just
close the table WITHOUT saving it, I am not prompted to save it.

1.  If Fastedit is ON, why does MI Pro think the table has unsaved edits
(i.e. the Save button lights)?
2.  If the Save button is lit, why am I allowed to close the table without
being prompted to save it?

Can anyone explain this?  Using MI Pro 6.5.

Thanks

Tim Nuteson
Target Corporation





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

MI-L Many questions

[mrusko]

Hi everybody,

I have a few questions for you. I am new to MapINFO but I have used other
GIS.
I want to develop an application which will communicate with Oracle
database server and which will display GIS information in MapINFO.
The application will create Queries upon user requests and then pass result
IDs to MapINFO, which should display and zoom to objects with those IDs.
We have around 20 000 objects in the database. All are attribute data.
The questions are:
- will MapINFO be able to handle large maps (more than 100MB) with
attribute data attached to it?
- is it possible to attach external database (Oracle 8i) to MapINFO?
- is it possible to externally Controll MapINFO through MapX? (not to
create my own mapping application, but to controll running MapINFO)
- how difficult is to change the whole system into Oracle Spatial
Technology? Are there any good tools which will make this easy?

Thank you very much. I will appreciate all your opinions.

Michal Rusko

--
MICHAL RUSKO
GIS specialist / developer



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

Re: MI-L OS Mastermap - Oracle Spatial

[bob young]

Dear David

By Design are MapInfo Premier Partners and have developed a MasterMap
Translator for MasterMap data.

Our translator MapGML runs as two seperate processes. The first takes OS
initial and update chunks as GZ files and maintains a local holding.
Stage 2 is a publishing stage which produces output for users from the
central holding. We can currently write to AutoCAD and to MapInfo and
would be interested in looking at other formats. Publishing includes
options for styling and for publishing by an area of interest or
complete coverage.

I guess the stage 1 output is what you would be most interested in where
you are wanting to publish to four formats. I am quite happy to discuss
this in detail if you would like to ring me.

If you or any customers would be interested in an evaluation copy please
email me or give me a ring on 01633 881117 and we can send you/them
copies. 

We are holding seminars in Newport, Windsor, London and Southampton on
MasterMap and our solutions during September and October. For anybody
interested in attending please contact By Design.


Bob Young 
By Design

www.mapsbydesign.co.uk
Tel (0044) 1633 881117





In message <8B2C45B3CF1CD611B93B000347087051329038@SGBBMB2001>, Eagle,
David A <[EMAIL PROTECTED]> writes
>Listers,
>
>A client of ours is looking to utilise the new OS Mastermap data that has
>superseded OS Landline. They have purchased some initial data but ultimately
>will purchase UK coverage. MapInfo is one of their GIS packages but they
>also use three others. Ideally it would be useful to store the data in one
>central location so that all 4 applications can draw off it, that way we
>minimise storage requirements and only one set of data need receive updates.
>
>I am beginning to research the use of databases and Oracle in particular but
>am finding it a difficult minefield to navigate through given my database
>knowledge (v. minimal). Can anyone share any experiences (or solutions) of
>similar issues relating to Mastermap or database use in general (with
>MapInfo or others). Mastermap is delivered in GML (Geographic Markup
>Language) format which should make multi application use through a database
>more feasible, however, my understanding of how MapInfo and other
>applications would access the data is also limited.
>
>Any thoughts greatly appreciated.
>Rgds, Dave
>
>--
>David A. Eagle
>GIS Consultant
>
>Atkins Design Environment
>& Engineering
>Cornerstone House
>Stafford Park 13, Telford
>Shropshire, TF3 3AZ
>England
>Tel:  +44 (0)1952 21 3268  * 
>Fax: +44 (0)1952 20 0981  *
>
>Email: [EMAIL PROTECTED]  *
>Web: www.atkinsglobal.com*
>
>
>
>
>
>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: 2253
>

-- 
bob young

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

MI-L Hotlink in ProViewer 6.5

[Luis Baptista]

Hi all,
 
I created a few workspaces to be seen by several departments. Most of them have 
MapInfoProViewer installed.
Some objects are "hotlinked". In MapInfo 6.5, when I select the hotlink the table is 
opened in the main window with the rest of the maps. When I do the same in Proviewer 
6.5 it opens a new Proviewer window with the file linked.
 
Does anyone can tell me what to do to have the same result in Proviewer as in 
Professional? 
maybe some options in "File Types" menu, under windows or something like that.
 
Thank you in advance
 
Luis
 
 
 



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

MI-L GPS Units

[Kearns, Gary]

Hi all,
 
Anybody got any recommendations for a decent MapInfo compatible GPS
receiver? The more basic the unit I can get away with, the better.

Thanks,

Gary Kearns 
GTECH Ireland Corporation 

MI-L 23rd UDMS, Prague

[Ken Jones]

23rd Urban Data Management Symposium, Prague October 2-5, 2002
'30 years of UDMS:
Looking back, looking forward'
3rd Conference on Municipal Information Systems
http://www.udms.net  


Opening Session: October 2, 2002: 13.00-14.30 hours 

Opening 

J. Hojdar, UDMS, DIGIM and Consultancy TERIS 

Use of IS/IT in the City of Prague 

J. Kasl, Lord Mayor of Prague, CZ 

Information Systems of Towns and Communities in the Czech Republic 

O. Vlasák, Chairman of the Union of Towns and Communities of the Czech
Republic 

Information Systems of Surveying and Cadastre 

K. Veèere, Head of the Czech Office for Surveying, Mapping and Cadastre 

30 years of UDMS - Looking back, looking forward 

M. Rumor, President of UDMS 

Establishing a sustainable GI policy forum 

Ch. Corbin, Chairman of AGI, EUROGI representative of AGI, EUROGI GINIE
Project Manager 

Organisation of the 3rd MIS and the 23rd UDMS 

J. Èálek, IMIP and DIGIM 



Parallel Session I: October 2, 2002: 15.00-17.00 hours
The Third Dimension 

Multiple use of land in space: current practice of registration and
development of a 3D Cadastre 

J.E. Stoter and H.D. Ploeger, Delft University of Technology, NL 

From 2Dbase map to 3D city model 

M. Arponen, City of Helsinki, FI 

Resource-adaptive 3D maps for Location Based Services 

V. Coors, Fraunhofer Institute for Computer Graphics, DL 

Virtual city models as a tool for urban tissue evaluation 

M. Hanzl, £odz Technical University, PL 

City Model and Representation 

G. Corso Pereira, Federal University of Bahia, BR 



Parallel Session II: October 2, 2002: 15.00-17.00 hours
Emergency, Risk and Disaster Management 

GIS in the World Trade Center Attack - Test by Fire 

M. Kevany, PlanGraphics Inc., USA 

Contribution to Spatial Decision Support System for flood insurance
claims assessment 

A. Napoli (1), F. Guarnieri (1) and R. Nussbaum (2), (1) Ecole des Mines de
Paris Pôle Cindyniques and (2) Mission Risques Naturels des Sociétés
d'Assurances, FR 

Digital system for natural disaster mitigation in China 

A. Tang (1), X. Tao (2), J. Ou (1) and J. Zhang, (1) Harbin Institute of
Technology, (2) China Seismological Institute and (3) Peking University, CN 

Change detection technology of city on remote sensing images and its
application in disaster assessment 

J-F Zhang (1, 2), L-L Xie (2) and Q. Qin (1) Peking University, (2) China
Seismological Institute, CN 



Parallel Session III October 2, 2002: 15.00-17.00 hours
Public Participation in the Physical Planning Process 

Evaluating the use of a Web-based Collaborative Interactive Digital
Model (CollABITA) in supporting the urban design approval process 

L. Burdi, Harvard University, USA 

Collaborative Decision Support for spatial planning applications 

H. Voss and A. Voss, Fraunhofer Institute AIS, DL 

Militant particularism: connecting the local to the global 

J. Lindsay, Kingston University, UK 

Proposition for a participative GIS leading to a cocerted
diagnostic, Application at the neighbourhood scale 

A. Nembrini and F. Joerin, University Centre of Human Ecology and
Environmental Sciences, University of Geneva, CH 

Internet presentation of large area unit plans: the Prague region
and other examples 

M. Kadlecová and M. Hadlaè, The Institute of Regional Information, Ltd., CZ 

A study on possibility of citizen opinion making via a
multi-functional electronic conference system 

T. Kobayashi and Y. Hibata, Keio University, JP 



Parallel Session IV: October 2, 2002: 15.00-17.00 hours
GINIE Pre-accession countries workshop: 
results and recommendations/debate
Ch. Corbin, EUROGI GINIE Project Manager, EUROGI and British AGI, UK


Parallel Sessions I: October 3, 2002
Decision Support Systems for Physical Planning: 08.30-10.00 hours 

Decision support for planning authorities: results of the EC PLAINS
project 

W. Cudlip (1), N. Davies (1), M. Barr (2), P. Semens (3), G. Fumera (4), F.
Roli (4) and A. Clematis (5), (1) QinetiQ Space, UK, (2) HTS Development,
UK, (3) ASH Consulting Group, UK, (4) Università degli Studi di Cagliari, IT
and (5) Istituto per la Matematica Applicata, CNR, IT 

A GIS approach to rural areas territorial plan 

G.P. Las Casas and B. Murgante, Università degli Studi della Basilicata, IT 

Using constrained cellular automata for urban future modelling 

J.I. Barredo, M. Kasanko, N. McCormick, L. Demicheli and C. Lavalle,
European Commission - Joint Research Centre, IT 

Linking GIS with CAD through the Web: a dynamic platform for
managing multi-dimensional urban datasets 

C. Peng and B. Lawson, University of Sheffield, UK 

A model for estimating energy demand on regional and local levels
with the help of GIS 

K. Bernotat and T. Sandberg, Royal Institute of Technology, SE 



Loc