This is a conditional update that in most databases can be excuted in a
single statement, but in MapInfo you need two a select and a update
statement:
Select * From FOOD
Where NAME In ("potatoe", "carrot", "squash")
Into TO__UPDATE NoSelect
Update TO__UPDATE
Set FOODTYPE = "vegetable"
Commit Table FOOD
Close Table TO__UPDATE
HTH
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
COWI GIS konference afvikles i dagene d. 2.-3. september.
Se yderligere oplysninger p� www.cowi.dk/Div04/Profiles/nyheder.asp
> -----Original Message-----
> From: Frank Aaron (TX/EUS) [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 15, 2003 12:14 AM
> To: MapInfo L (E-mail)
> Subject: MI-L Select/Insertion within Same Table
>
>
> Hi,
>
> Does anyone know how to select from one table (using a
> conditional statement) and then insert the resulting data
> into a empty column within said table. For example, if column
> B has as its possible entries (potatoe, carrot & squash) -
> add vegetable to column C. Thanks,
>
> Frank
>
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8034
