Longitude field
I created a table and form for data, which includes a latitude and longitude field. Lat and Long date will be entered as degrees decimal. The lat/long data will be used for mapping purposes (exported to a GIS). For proper mapping, the longitude data must be negative. I don't want to rely on the user to remember to put a negative sign in front of their longitude data at the time of input. Is there a way that I can set up the field to automatically put a negative sign in front of the longitude value, if the user forgets to do it? Basically, I want to make sure that all data in the longitude field starts with a negative sign.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 10, 2008 1:42 PM
UPDATED:
September 10, 2008 2:29 PM
RELATED QUESTIONS
- FTP negative numbers from a flat text file to the iSeries. We use Reflections 5250 terminal
- How can I affect the user profile previous sign-on date with out sign on interactive.
- Creating raster in Matlab using Excel file and calculating averages
- Replacement for MS FrontPage
- Trying to run remote command to view AS/400 UNC and failing!
Answer Wiki:
You would need to setup the UI which the user users to enter the data to handle this. But what if the user needs to enter a location in Europe or Africa? In which case the longitude would need to be a positive number.
If you are using a stored procedure you could put logic in the stored procedure to multiple the value by -1 if the value is greater than 0.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
