I forgot about val. Thank you for taking time out of your day to answer my silly questions.
Marty -----Original Message----- From: Uffe Kousgaard [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 9:57 AM To: Mapinfo-L Subject: Re: MI-L Data type mismatch mid$ returns a string and you can't divide that by 60: (( val(Mid$(LONGITUDE,3,3)) + val(Mid$(LONGITUDE,6,7)) / 60 ) * (-1) Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "Sprenz, Marty" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, July 28, 2005 4:51 PM Subject: MI-L Data type mismatch > Hello again, I'm getting a data type mismatch error with the following sql > statement: ((Mid$(LONGITUDE,3,3)+(Mid$(LONGITUDE,6,7)/60))*-1) > "LONGITUDE". > I broke down the statement and the problem is to the right of the plus > sign. > The value of the field looks like this: W 11521.0460. I need to get rid > of > the W then add the 115 to the equation of (21.0460 / 60) then multiply all > of that by -1. (115+(21.0460 / 60))*-1. Any solutions? Why does this > sql > statement work in every program I've ever used that accepts sql statements > but not in MI. Does it use some different form of sql? > > > > Thanks in advance, > > > > Marty Sprenz (RF Engineer - Contractor) > > 100 Concourse Pkwy > > Birmingham, AL 35244 > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > Office: 205-444-3572 > > Mobile: 404-509-9820 > > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17294
