I've a relative who's "simple", but I still couldn't get this query to work.
Dave -----Original Message----- From: Spencer Simpson [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 1:44 PM To: 'David Reid'; [email protected] Subject: RE: MI-L SUM: Need IF statement to update column "simple" is relative, I guess. The way you're going about it seems overly complicated to me. For what you're doing here, you would perform a query and update the query: Select * from MYTAB where instr (1, TEMP, "%%d") into D noselect Update NO_D set BEARING=TEMP HTH Spencer -----Original Message----- From: David Reid [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 2:19 PM To: [email protected] Subject: MI-L SUM: Need IF statement to update column It would appear the simple thing to do is export to a text file, update the columns in Excel or Access, then dump the stuff back into MI In Excel, my solution was to use the following formula: For column A =If(find("%%d"),A4),A4,"") Thanks, Dave -----Original Message----- From: David Reid [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 12:39 PM To: [email protected] Subject: MI-L Need IF statement to update column Greetings List, I've seen references to this before but never seem to find what will apply to the need at the time. I know there's no "IF" statement for use in Mapinfo but realize there's a way around this but I can't seem to find the path :) <Do this> IF() IF() <do this> ELSE(<do this>) I wish to update a column with specific data from another, Update BEARING with TEMP If "%%d" is found in TEMP ELSE <don't do anything> %%d is literal, not wild cards "%". This data was converted from a DWG file. Thanks, David Reid -- Outgoing mail is certified Virus Free Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 07/12/2005 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17117 -- Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 07/12/2005 -- Outgoing mail is certified Virus Free Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 07/12/2005 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17122 -- Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 07/12/2005 -- Outgoing mail is certified Virus Free Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 07/12/2005 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17124
