Hello,
I think i can help you, you must use this expression to achieve you want :
Select * From yourtable
Where col1 ="Slight"
Update Selection
Set col2 = 1
Good luck
Sophie Coubes
____________________________________________
KOREM (http://www.korem.com)
G�Odiffusion de l'information
GEObroadcasting your information
____________________________________________
Best Mapinfo New Partner 2000 - North America
____________________________________________
Sophie Coub�s
Conseill�re en G�omatique
GIS Consultant
KOREM Inc.
680, Boul. Charest Est
Qu�bec (Qu�bec) CANADA G1K 3J4
t�l.: 418 647-1555
fax : 418 647-1666
T�l�phone sans frais : 1 888 440-1MAP
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de David
Eagle
Envoy� : 3 mai, 2001 05:12
� : MapInfo-L (E-mail)
Objet : MI-L IF Statement
I'm struggling with an expression can anyone help?
I have a table containing accidents of different severity levels. I want to
update a new column in the same table with an integer that relates to the
severity eg. If Col1 = "Slight" update Col2 with "1". Can I use an IF
statement to achieve this?
Thanks, Dave
----------------------------------------
David A Eagle - GIS Specialist
Transport Planning
WS Atkins Consultants Ltd
Wellbrook Court, Girton Road
Cambridge, CB3 0NA
Tel: 01223 814090
E-mail: [EMAIL PROTECTED]
----------------------------------------
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, 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.
