Subject: | Field picture
| Date: | Thu, 22 Aug 2019 11:12:05 +0100
| From: | feargal <feargal.hogan@gmail.com>
| Newsgroups: | pnews.paradox-development
|
Hi
I'm trying to figure out the field picture for degrees, minutes and
seconds in degrees mins secs data entry?
This is for entering Latitudes and longitudes
These will be stored in a SQL Server as a Decimal field, so these data
entry fields are unbound
So for Latitude Degrees it will be an short integer datatype, between 0
and 89 (90 is a special case where the min/sec fields MUST be zero)
Longitude degrees will be between 0 and 179 (180 is a similar special case)
Minutes for both will be a short integer datatype between 0 and 59
Seconds will be a decimal datatype ##.##
How much of that can I specify in a field picture?
And how much needs to be done pre-depart?
|