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
