Hi Steve,
Try this:
Update <table_name> Set <Column_name> = LCase$(<Column_name>)
A+
Fran�ois Robitaille
Conseiller en g�omatique
SiGis
514.285.9595
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de Morrier,
Steve
Envoy� : 26 septembre, 2001 16:50
� : [EMAIL PROTECTED]
Objet : MI-L Lower Case
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Hi all,
Is there a quick way to convert all upper case letters in a column to lower
case letters? TIA.
Steve
-----Original Message-----
From: Karen Purdy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 12:51 PM
To: [EMAIL PROTECTED]
Subject: MI-L Re: slow workspaces: SUM
Dear List
many thanks for your suggestions. Several people have shown an interest in
the results of this, so here's a summary (after the problem repeated
below)...
>Dear List
>
>Has anyone had any experience of speeding up slow opening workspaces?
>
>I have some workspaces that open really slowly (takes several minutes),
>while other almost identical ones open fast (eg 20 seconds). This is VERY
>frustrating for users.
>
>I examined what the workspaces were doing by putting 'Note' commands
between
>each workspace line to pause the workspace after each command. It seems
>that the slow part is the 'Map From' command.
>
>The 'Map From' command draws all the data sets in the window before the
'Set
>Map' command repositions the map view coordinates and zoom level. In the
>slow opening workspaces I tested the scale of the intial map was much
>smaller (zoomed out to cover a wide region), and so took a long time to
draw
>especially with large data sets such as the OS Landline. For some reason
>the faster workspaces created an initial map covering a much smaller area
>and so took much less time to draw.
>
>So I guess the question is - how can I control the scale of the initial map
>created in 'Map From' so that this bit can be opened really zoomed in? It
>does not seem to matter which data layer is first in the 'Map From'
command,
>and I cannot add data layers to the map after opening as these workspaces
>are also used in ProViewer
>
>Any help greatly appreciated.
>
>Many thanks
>Karen
>
There were two main types of reply - one to edit the workspace, one to
change the Table settings...
Tables:
Open a Table you wish to use in the workspace, zoom in really close, then
open the MapBasic Window and type the following:-
Set Map Layer 1 Default Zoom.
Next time you open this Table the map window will then be created to this
pre-set zoom. I tried this with just the first Table in the workspace, and
it had no effect, so presumably you would have to do it for all Tables
rather than just one. Also if your workspace runs queries and adds these to
the map window, their zoom levels will not have been set - with any of my
workspaces that contained selections, this meant the workspace still opened
slowly.
Workspaces:
Edit your workspace file so that 'Map From' only opens one layer, ideally a
small layer. Add the following commands:
Set Map Redraw Off
Add Map Layer <OTHER LAYER TABLE NAMES TO ADD>
Set Map <coordinates, zoom, distance units etc...>
Set Map Redraw On
This seems to work fine if you have a small file to create the map window
from, but it seems that this layer is then the bottom layer so you need to
also swap around your layer display clauses in Set Map to compensate.
Combination:
If you don't want to set all of your Tables, or want to get around the
problem with layers created from queries, a combination of the above two
methods also works well. By setting just the zoom default of one Table, and
then using this as the only layer in the 'Map From' statement as above, and
adding the other layers with the Add Map Layer command in the workspace.
Suggestions at the time of this email were from Paul Crisp (Syntegra), David
Booth (Merseyside Information Service), Ian Hull (Greater Manchester
Transportation Unit), and Bob Young (By Design) - THANKS AGAIN TO ALL OF
YOU. Problem solved!
Karen
==========================
Karen Purdy
GIS Support Officer
Peak District National Park Authority
Aldern House
Baslow Road
Bakewell
Derbyshire DE45 1AE
Email: [EMAIL PROTECTED]
Telephone (direct): 01629 816269
Tel (switchboard): 01629 816200
==========================
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
Star Internet for details on the Virus Scanning Service.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
----------------------------------------------------------------------------
This communication (including all attachments) is intended solely for the
use of the person or persons to whom it is addressed and should be treated
as a confidential xwave communication. If you are not the intended
recipient, any use, distribution, printing, or copying of this email is
strictly prohibited. If you received this email in error, please
immediately delete it from your system and notify the originator. Your
cooperation is appreciated.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
