Paradox Community

Items in pnews.paradox-development

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?


Copyright © 2004 thedbcommunity.com