I cannot use rounded figures.

I use these numbers for unique ID ("EntryID") in the first field of my 
table. I need to be able to insert new records in between sequentially 
numbered records:
e.g.
1
2
3
4
5

May need to become
1
1.1
2
3
4
5

Further it may need to become
1
1.01
1.02
1.03
1.1
2
3
4
5

Getting crazy
1
1.01
1.001
1.002
1.02
1.03
1.1
2
3
4
5


In reality the adjustments will never get past 3 decimal places, but 
then Gates/Allen never thought anyone would need more than 1mb of memory.

So I cannot set the format to "x" decimal places because the places is 
limitless - well 15 digits actually

a number such as 1.103555555555566 is unusable

I solved the problem by separating a number into 2 strings
left of decimal
right of decimal

There is an awful lot of screwing around to increment/decrement the 
decimal part but it basically involves establishing numbers by putting 
them into an undefined field formatted as 15 decimals
"UfldDec = entryid" (N) in the first fld of the tbl
and then retrieving as a string
"StrDec = UfldDec"

Once I have the decimal formatted as a string it cannot be reverted to a 
number for calclations because then the answer is back to 15 digits, so 
the calculations have to be done with strings. Yeesh!



On 9/19/2020 8:38 AM, Steven Green wrote:
> numbers are interesting.. do you want the round of the sums, or the sum 
> of a bunch of rounds.. by setting a "default" number of places, that's 
> what you're doing
> 
> 
> -- 
> 
> Steven Green
> Myrtle Beach, South Carolina, USA
> 
> http://www.OasisTradingPost.com
> 
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
> "Peter"  wrote in message news:5f651f65$1@pnews.thedbcommunity.com...
> 
> I sure do hate calculating with decimals in Pdox.
> 
> I found that I needed at the beginning of my code
> "formatSetNumberDefault("Dec15")"
> to be able to get all the decimals I need; the number of decimals is
> completely fluid.
> 
> At the end of the code I have
> "formatSetNumberDefault("Fixed")"
> 
> Is there a way to get the default number format? Thank you.
> 
> 
> Peter